Forum Discussion
Time Intelligence DAX formula
Hi, I do have a COUNT measure and now i would like to calculate count based on following criteria ; Current year Count which is YTD till now (I got that by TOTALYTD syntex), Count till now base...
Hi damit23183,
You can also take a look at the following blog to use the date function to achieve time intelligence. They are more agility than time intelligence functions and not require a calendar table and they can be nested with other functions:
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng