Forum Discussion

DenisStyrt's avatar
DenisStyrt
Icon for Helper II rankHelper II
5 years ago

LTM Calculation on a measure

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

DenisStyrt , You calculation is not very clear to me but you can take advantage of Time Intelligence and date table

 

example


QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

 

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 :radacad sqlbi My Video Series Appreciate your Kudos.