Hi, I am trying to create an LTM calculation based on another calculated measure. Here is the sample data:
Lost Logos in Q formula is(working as expected):
if([New Logo In Q]>0,[New Logo In Q]-([Total Logos]-[Number of Logos previous Q]),BLANK())
Lost Logos LTM V2 formula is(not working and just giving me the same numbers):
CALCULATE([Lost Logos in Q],DATESINPERIOD(Account_Vs_Month[Date Beginning Of Month],MAX(Account_Vs_Month[Date Beginning Of Month]),-12,MONTH)) I tried many other combinations but always recive the same values and not the LTM sum.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacadsqlbiMy Video Series Appreciate your Kudos.