Time intelligence function

[Anonymous]

Hello Community,

I  have a data that consists on date column  with only month and year,,,, but i wanted to use time intelligence function,, Is it possible,, If possible, Can you suggest me ?? 

Thanks in advance 

[MattAllington · Accepted solution]

Yes, but you can't use the inbuilt functions.  You need to write custom time intelligence. Create a month calendar table with the same month-year column as your data table (one column, such as mmm-yyyy). Make sure your calendar table has a monthID column (integer, starting at 1 and incrementing by 1 for every month in your calendar, never resetting). You can then use this column in your formulas, like this

same period prior year = 

CALCULATE([measure],FILTER(ALL(CALENDAR),calendar[monthID] = max(calendar[monthID])-12))

i have an article here that will help you https://exceleratorbi.com.au/dax-time-intelligence-beginners/