Forum Discussion
Problems with Year to date comparisons
The inbuilt time intelligence functions that you are using work on dates, not week numbers. So 3 Jan May be week 2 one year and week 1 the year after (for example). If you want to report on like for like week numbers, you need to write a custom time intelligence function. Read my article here
https://exceleratorbi.com.au/dax-time-intelligence-beginners/
The inbuilt time intelligence functions that you are using work on dates, not week numbers. So 3 Jan May be week 2 one year and week 1 the year after (for example). If you want to report on like for like week numbers, you need to write a custom time intelligence function. Read my article here
https://exceleratorbi.com.au/dax-time-intelligence-beginners/
Thanks Matt, very well written blog post, helped a lot.