<map version="freeplane 1.8.0">
<!--To view this file, download free mind mapping software Freeplane from http://freeplane.sourceforge.net -->
<node TEXT="Time Intelligence in Power BI" FOLDED="false" ID="ID_1654726283" CREATED="1595422577898" MODIFIED="1595589551157" ICON_SIZE="40.0 pt" STYLE="oval">
<icon BUILTIN="password"/>
<font SIZE="18"/>
<hook NAME="MapStyle" zoom="0.909">
    <properties fit_to_viewport="false" edgeColorConfiguration="#808080ff,#ff0000ff,#0000ffff,#00ff00ff,#ff00ffff,#00ffffff,#7c0000ff,#00007cff,#007c00ff,#7c007cff,#007c7cff,#7c7c00ff"/>

<map_styles>
<stylenode LOCALIZED_TEXT="styles.root_node" STYLE="oval" UNIFORM_SHAPE="true" VGAP_QUANTITY="24.0 pt">
<font SIZE="24"/>
<stylenode LOCALIZED_TEXT="styles.predefined" POSITION="right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="default" ICON_SIZE="12.0 pt" COLOR="#000000">
<font NAME="SansSerif" SIZE="16" BOLD="false" ITALIC="false"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.details"/>
<stylenode LOCALIZED_TEXT="defaultstyle.attributes">
<font SIZE="9"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.note" COLOR="#000000" BACKGROUND_COLOR="#ffffff" TEXT_ALIGN="LEFT"/>
<stylenode LOCALIZED_TEXT="defaultstyle.floating">
<edge STYLE="hide_edge"/>
<cloud COLOR="#f0f0f0" SHAPE="ROUND_RECT"/>
</stylenode>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.user-defined" POSITION="right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="styles.topic" COLOR="#18898b" STYLE="fork">
<font NAME="Liberation Sans" SIZE="10" BOLD="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.subtopic" COLOR="#cc3300" STYLE="fork">
<font NAME="Liberation Sans" SIZE="10" BOLD="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.subsubtopic" COLOR="#669900">
<font NAME="Liberation Sans" SIZE="10" BOLD="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.important">
<icon BUILTIN="yes"/>
</stylenode>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.AutomaticLayout" POSITION="right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="AutomaticLayout.level.root" COLOR="#000000" STYLE="oval" SHAPE_HORIZONTAL_MARGIN="10.0 pt" SHAPE_VERTICAL_MARGIN="10.0 pt">
<font SIZE="18"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,1" COLOR="#0033ff">
<font SIZE="16"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,2" COLOR="#00b439">
<font SIZE="14"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,3" COLOR="#990000">
<font SIZE="12"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,4" COLOR="#111111">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,5"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,6"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,7"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,8"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,9"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,10"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,11"/>
</stylenode>
</stylenode>
</map_styles>
</hook>
<hook NAME="AutomaticEdgeColor" COUNTER="6" RULE="ON_BRANCH_CREATION"/>
<node TEXT="What is Time Intelligence" POSITION="right" ID="ID_441267430" CREATED="1595422647683" MODIFIED="1595589543577" ICON_SIZE="28.0 pt" STYLE="bubble">
<icon BUILTIN="idea"/>
<font SIZE="16"/>
<edge COLOR="#0000ff"/>
<node TEXT="Time as a Dimension/Measure" ID="ID_1618919439" CREATED="1595422698773" MODIFIED="1595422709433"/>
<node TEXT="Time?" FOLDED="true" ID="ID_1796430887" CREATED="1595578792031" MODIFIED="1595578802771">
<node TEXT="Time is the indefinite continued progress of existence and events that occur in an apparently irreversible succession from the past, through the present, into the future." ID="ID_1361436745" CREATED="1595578804341" MODIFIED="1595578805941"/>
</node>
<node TEXT="Intelligence?" FOLDED="true" ID="ID_489263815" CREATED="1595575981293" MODIFIED="1595575986163">
<node TEXT="logic, understanding, self-awareness, learning, knowledge, reasoning, planning, creativity, critical thinking, and problem-solving" ID="ID_15006925" CREATED="1595575986913" MODIFIED="1595576013213"/>
</node>
</node>
<node TEXT="Importance of Date Table" FOLDED="true" POSITION="right" ID="ID_921762237" CREATED="1595422667123" MODIFIED="1595589543577" ICON_SIZE="28.0 pt" STYLE="bubble" HGAP_QUANTITY="18.499999865889553 pt" VSHIFT_QUANTITY="-2.2499999329447764 pt">
<icon BUILTIN="calendar"/>
<font SIZE="16"/>
<edge COLOR="#00ff00"/>
<node TEXT="What is it?" FOLDED="true" ID="ID_1811235256" CREATED="1595424614798" MODIFIED="1595424618388">
<node TEXT="A table/list of unique, continuous and contiguous dates of the data range." ID="ID_328153369" CREATED="1595424619928" MODIFIED="1595578865407"/>
</node>
<node TEXT="Where to start?" FOLDED="true" ID="ID_1601718920" CREATED="1595578837847" MODIFIED="1595578844187">
<node TEXT="Measuring Tape" ID="ID_1405519626" CREATED="1595578845377" MODIFIED="1595578846427"/>
</node>
<node TEXT="What about the interval?" FOLDED="true" ID="ID_1639370986" CREATED="1595422811375" MODIFIED="1595422822635">
<node TEXT="Day" ID="ID_1172418430" CREATED="1595578872897" MODIFIED="1595578875497"/>
<node TEXT="Hour" ID="ID_1332972753" CREATED="1595578876527" MODIFIED="1595578877957"/>
</node>
<node TEXT="Unique Records?" ID="ID_878909924" CREATED="1595422823595" MODIFIED="1595422848896"/>
<node TEXT="How To Create?" ID="ID_1655980750" CREATED="1595423765051" MODIFIED="1595423769261">
<node TEXT="Power Query" FOLDED="true" ID="ID_7475597" CREATED="1595423770391" MODIFIED="1595423834098">
<node TEXT="{ Number.From( List.Min( datefield)).. Number.From( List.Max( datefield))}" ID="ID_1205148718" CREATED="1595423777131" MODIFIED="1595423838628"/>
</node>
<node TEXT="Power BI" FOLDED="true" ID="ID_96669658" CREATED="1595423772731" MODIFIED="1595423774931">
<node TEXT="CALENDARAUTO(3)" ID="ID_1773614544" CREATED="1595424190680" MODIFIED="1595424192640"/>
<node TEXT="Calendar( dStart, dEnd )" ID="ID_1368553481" CREATED="1595424194410" MODIFIED="1595425387523"/>
<node TEXT="StartofYear(), Quarter(), Month()" ID="ID_1744260627" CREATED="1595425348356" MODIFIED="1595425374482"/>
<node TEXT="Format( date, &quot;M&quot; ), &quot;MM&quot;, &quot;MMM&quot;, &quot;MMMM&quot;" ID="ID_121359639" CREATED="1595425572217" MODIFIED="1595425593721"/>
</node>
<node TEXT="Points to be considered" ID="ID_703871480" CREATED="1595488815595" MODIFIED="1595488820105">
<node TEXT="Financial Year" ID="ID_1753594985" CREATED="1595488823685" MODIFIED="1595488827435"/>
<node TEXT="Quarter" ID="ID_935665344" CREATED="1595488827865" MODIFIED="1595488829723"/>
<node TEXT="Monthname, month" ID="ID_1145737747" CREATED="1595488830093" MODIFIED="1595488837783"/>
<node TEXT="Sort by Column" ID="ID_1690287396" CREATED="1595488853113" MODIFIED="1595488857943"/>
</node>
</node>
<node TEXT="Multiple Date Columns?" ID="ID_1046798381" CREATED="1595424943765" MODIFIED="1595424948545">
<node TEXT="UseRelationship()" ID="ID_1559502034" CREATED="1595424955195" MODIFIED="1595424966915"/>
</node>
</node>
<node TEXT="Time Intelligence Functions" FOLDED="true" POSITION="right" ID="ID_245874787" CREATED="1595493118320" MODIFIED="1595589543587" ICON_SIZE="28.0 pt" STYLE="bubble">
<icon BUILTIN="clock"/>
<edge COLOR="#ff00ff"/>
<node TEXT="Todate" FOLDED="true" ID="ID_1052709096" CREATED="1595493125720" MODIFIED="1595493454285">
<node TEXT="TotalYTD" ID="ID_1405694760" CREATED="1595493135570" MODIFIED="1595493150310"/>
<node TEXT="TotalQTD" ID="ID_1187683106" CREATED="1595493150770" MODIFIED="1595493154760"/>
<node TEXT="TotalMTD" ID="ID_486300568" CREATED="1595493155050" MODIFIED="1595493159840"/>
<node TEXT="DatesYTD" ID="ID_1721557683" CREATED="1595493456925" MODIFIED="1595493484596"/>
<node TEXT="DatesQTD" ID="ID_669617976" CREATED="1595493460375" MODIFIED="1595493488496"/>
<node TEXT="DatesMTD" ID="ID_1422501791" CREATED="1595493463885" MODIFIED="1595493490606"/>
</node>
<node TEXT="SamePeriodLastYear" ID="ID_739754995" CREATED="1595493161730" MODIFIED="1595493171410"/>
<node TEXT="ParallelPeriod" ID="ID_273916403" CREATED="1595493496086" MODIFIED="1595493501276"/>
<node TEXT="Date" FOLDED="true" ID="ID_210547018" CREATED="1595493172090" MODIFIED="1595493333206">
<node TEXT="DateAdd" ID="ID_868040638" CREATED="1595493334286" MODIFIED="1595493336316"/>
<node TEXT="DatesBetween" ID="ID_1787692568" CREATED="1595493336646" MODIFIED="1595493434082"/>
<node TEXT="DatesInPeriod" ID="ID_1186291206" CREATED="1595493434472" MODIFIED="1595493439522"/>
</node>
<node TEXT="Previous-Next" FOLDED="true" ID="ID_112339382" CREATED="1595493548525" MODIFIED="1595493553435">
<node TEXT="PreviousDay" ID="ID_1092799910" CREATED="1595493555765" MODIFIED="1595493562095"/>
<node TEXT="PreviousMonth" ID="ID_1676020977" CREATED="1595493562525" MODIFIED="1595493565515"/>
<node TEXT="PreviousQuarter" ID="ID_1000675373" CREATED="1595493565705" MODIFIED="1595493569789"/>
<node TEXT="PreviousYear" ID="ID_1339157280" CREATED="1595493570139" MODIFIED="1595493574239"/>
<node TEXT="NextDay" ID="ID_1844985162" CREATED="1595493586794" MODIFIED="1595493590454"/>
<node TEXT="NextMonth" ID="ID_1726615076" CREATED="1595493590851" MODIFIED="1595493592831"/>
<node TEXT="NextQuarter" ID="ID_1181302855" CREATED="1595493593201" MODIFIED="1595493596221"/>
<node TEXT="NextYear" ID="ID_1500704419" CREATED="1595493596531" MODIFIED="1595493599501"/>
</node>
<node TEXT="Opening-Closing" FOLDED="true" ID="ID_979867173" CREATED="1595493620071" MODIFIED="1595493623551">
<node TEXT="OpeningBalanceMonth" ID="ID_250419001" CREATED="1595493624571" MODIFIED="1595493630449"/>
<node TEXT="OpeningBalanceQuarter" ID="ID_1358209905" CREATED="1595493630709" MODIFIED="1595493635139"/>
<node TEXT="OpeningBalanceYear" ID="ID_1620815395" CREATED="1595493635309" MODIFIED="1595493638689"/>
<node TEXT="ClosingBalanceMonth" ID="ID_978384831" CREATED="1595493639349" MODIFIED="1595493643509"/>
<node TEXT="ClosingBalanceQuarter" ID="ID_673109646" CREATED="1595493643659" MODIFIED="1595493648109"/>
<node TEXT="ClosingBalanceYear" ID="ID_1064862781" CREATED="1595493648499" MODIFIED="1595493652919"/>
</node>
<node TEXT="Start-End" FOLDED="true" ID="ID_1936560933" CREATED="1595493672099" MODIFIED="1595493675189">
<node TEXT="StartofTheMonth" ID="ID_828434369" CREATED="1595493676469" MODIFIED="1595493681589"/>
<node TEXT="StartofTheQuarter" ID="ID_1273185323" CREATED="1595493681799" MODIFIED="1595493686909"/>
<node TEXT="StartofTheYear" ID="ID_335373271" CREATED="1595493687259" MODIFIED="1595493690724"/>
<node TEXT="EndofTheMonth" ID="ID_1247500898" CREATED="1595493691214" MODIFIED="1595493695724"/>
<node TEXT="EndofTheQuarter" ID="ID_488559804" CREATED="1595493696074" MODIFIED="1595493703885"/>
<node TEXT="EndofTheMonth" ID="ID_1403044773" CREATED="1595493704085" MODIFIED="1595493708115"/>
</node>
<node TEXT="First-Last" FOLDED="true" ID="ID_324933971" CREATED="1595494182775" MODIFIED="1595494186759">
<node TEXT="FirstDate" ID="ID_1231387323" CREATED="1595494189925" MODIFIED="1595494191825"/>
<node TEXT="FirstNonBlank" ID="ID_1407086673" CREATED="1595494192285" MODIFIED="1595494195255"/>
<node TEXT="FirstNonBlankValue" ID="ID_1591781758" CREATED="1595494195485" MODIFIED="1595494200345"/>
<node TEXT="LastDate" ID="ID_333935867" CREATED="1595494200705" MODIFIED="1595494202305"/>
<node TEXT="LastNonBlank" ID="ID_308697894" CREATED="1595494202575" MODIFIED="1595494205785"/>
<node TEXT="LastNonBlankValue" ID="ID_1734008781" CREATED="1595494205935" MODIFIED="1595494210255"/>
</node>
</node>
<node TEXT="Other Date Functions" FOLDED="true" POSITION="right" ID="ID_287542891" CREATED="1595566917579" MODIFIED="1595589543587" ICON_SIZE="28.0 pt" STYLE="bubble">
<icon BUILTIN="hourglass"/>
<edge COLOR="#7c0000"/>
<node TEXT="Calendar" FOLDED="true" ID="ID_1526301113" CREATED="1595566968068" MODIFIED="1595566971018">
<node TEXT="Calendar" ID="ID_514581117" CREATED="1595566972148" MODIFIED="1595566974398"/>
<node TEXT="CalendarAuto" ID="ID_1224519779" CREATED="1595566974788" MODIFIED="1595566978818"/>
</node>
<node TEXT="Create Date" FOLDED="true" ID="ID_27012369" CREATED="1595567234008" MODIFIED="1595567241418">
<node TEXT="Date" ID="ID_1438855545" CREATED="1595567242558" MODIFIED="1595567243928"/>
<node TEXT="Time" ID="ID_582451632" CREATED="1595567244268" MODIFIED="1595567245838"/>
<node TEXT="DateValue" ID="ID_922461671" CREATED="1595567309798" MODIFIED="1595567311978"/>
<node TEXT="TimeValue" ID="ID_157781959" CREATED="1595567312218" MODIFIED="1595567314238"/>
</node>
<node TEXT="Extract from Date" FOLDED="true" ID="ID_1966842964" CREATED="1595566980498" MODIFIED="1595567025928">
<node TEXT="Day" ID="ID_1137723982" CREATED="1595567029378" MODIFIED="1595567030928"/>
<node TEXT="Month" ID="ID_55463860" CREATED="1595567031238" MODIFIED="1595567032788"/>
<node TEXT="WeekDay" ID="ID_73000571" CREATED="1595567033048" MODIFIED="1595567123758"/>
<node TEXT="WeekNum" ID="ID_1498532070" CREATED="1595567124278" MODIFIED="1595567127468"/>
<node TEXT="Year" ID="ID_1320125181" CREATED="1595567036128" MODIFIED="1595567037538"/>
<node TEXT="Hour" ID="ID_953185790" CREATED="1595567061688" MODIFIED="1595567062778"/>
<node TEXT="Minute" ID="ID_1008869140" CREATED="1595567062928" MODIFIED="1595567064248"/>
<node TEXT="Second" ID="ID_1354085438" CREATED="1595567064458" MODIFIED="1595567065748"/>
</node>
<node TEXT="Calculate from Date" FOLDED="true" ID="ID_1168244735" CREATED="1595567073008" MODIFIED="1595567170988">
<node TEXT="EDate" ID="ID_940433704" CREATED="1595567082468" MODIFIED="1595567085788"/>
<node TEXT="EoMonth" ID="ID_853562766" CREATED="1595567086058" MODIFIED="1595567088438"/>
<node TEXT="DateDiff" ID="ID_719075333" CREATED="1595567096838" MODIFIED="1595567101718"/>
</node>
<node TEXT="Get Today&apos;s Date" FOLDED="true" ID="ID_138348427" CREATED="1595567171808" MODIFIED="1595567189418">
<node TEXT="Now" ID="ID_1004708814" CREATED="1595567191478" MODIFIED="1595567193268"/>
<node TEXT="Today" ID="ID_596773246" CREATED="1595567193588" MODIFIED="1595567195848"/>
<node TEXT="UTCNow" ID="ID_875668844" CREATED="1595567205688" MODIFIED="1595567208008"/>
<node TEXT="UTCToday" ID="ID_556454" CREATED="1595567208258" MODIFIED="1595567211698"/>
</node>
</node>
<node TEXT="Useful Quick Measures" POSITION="right" ID="ID_241990679" CREATED="1595494369692" MODIFIED="1595589543577" ICON_SIZE="28.0 pt" STYLE="bubble">
<icon BUILTIN="wizard"/>
<edge COLOR="#00ffff"/>
<node TEXT="Year over Year Change %" ID="ID_598050502" CREATED="1595494378798" MODIFIED="1595494414996"/>
<node TEXT="Quarter over Quarter Change %" ID="ID_240893234" CREATED="1595494397311" MODIFIED="1595494405225"/>
<node TEXT="Month over Month Change %" ID="ID_1911100652" CREATED="1595494416316" MODIFIED="1595494422536"/>
<node TEXT="Running Average" ID="ID_760482386" CREATED="1595495082844" MODIFIED="1595495094624"/>
</node>
<node TEXT="CA S. Rathinagiri" LOCALIZED_STYLE_REF="defaultstyle.floating" POSITION="right" ID="ID_1293920094" CREATED="1595589068444" MODIFIED="1595589298846" HGAP_QUANTITY="75.74999774247412 pt" VSHIFT_QUANTITY="87.7499973848463 pt">
<hook NAME="FreeNode"/>
<node TEXT=" srathinagiri@gmail.com" ID="ID_1472485929" CREATED="1595589260133" MODIFIED="1595589561607" ICON_SIZE="20.0 pt" LINK="mailto:srathinagiri@gmail.com" HGAP_QUANTITY="-147.24999519437566 pt" VSHIFT_QUANTITY="26.249999217689062 pt"/>
</node>
</node>
</map>
