Forum Discussion
Eldin
4 years agoRegular Visitor
Time Periods
Hello, I've been searching a lot for some good Time Periods in DAX or M Queries, but can't seem to find something that helps me. Everytime there is something missing in order to get the full solu...
- 4 years ago
I found what I was searching for somewhere else:
Alex_T
4 years agoFrequent Visitor
Hi Eldin ,
Nice find, that Chris Webb stuff is very good, you may also want to check out...
Guy in a Cube, who discusses this stuff, Working with Time Periods in Power BI - YouTube
They reference a Phil Seamark article on this, Row-based Time Intelligence - Phil Seamark on DAX who offer a DAX and TSQL solution and to Fourmoo, Create Dynamic Periods for Fiscal or Calendar Dates in Power BI - Data Analytics | FourMoo and Power BI who offer more on M-query solution (and refer to another Seamark article).
Love this stuff, hopefully we'll be having an implementation of this in our Data Warehouse soon, good for the users but also good for devs as it can simplify our measures 🙂