Forum Discussion

thx1137's avatar
thx1137
Helper I
2 years ago

Time Intelligence with Period Table (not Date Table)

All,

Would like to use the built-in time intelligence functions (e.g. YoY, ClosingBalanceMonth, etc) however our DWH has a fiscal period dimension that includes 12 periods for year (not 365 days) to align with our data (which is tied to financial data) and we've made that part of the data set.

 

Due to not having a date row for every day of the year, I can't mark it as a Date Table.  Any alternative approaches?  One thought was to created a calculated table with the appropriate fiscal period alignment (our FY start date is 1 March) and then join that in.

 

Any downsides to this approach?  Any better approaches?

 

Thx!

1 Reply

  • Yep creating a calculated table (whether that's in DAX, PowerQuery or wherever you get your data) would be recommended.