Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

TTM Calculation

Hello,

Is there a way to do the TTM Calculations, such that addition of revenue from jan-19 to dec-19 is reflected in the dec month. sum of revenue from feb-19 to jan -20 is reflected in jan-10 month, sum of mar-19 to feb -20 revenue is reflected in feb-20 month and so on.

I am using this formulae but it is reflecting incorrect values

 

CALCULATE(SUM('Budget , Revenue , Bookings'[Amount]),
DATESINPERIOD('Date'[Date], LASTDATE('Date'[Date]),-12, MONTH))
 
Thanks in anticipation
Need Help
Show and Tell
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    For the dax formula you created, it returns the sum of the most recent 12 months starting from the last day of the period in the filtering context. Add the measure to the table, the result can be obtained correctly, I did a test, refer to the following:

    M = 
CALCULATE (
    SUM ( 'Table'[Value] ),
    DATESINPERIOD ( 'Table'[Date], LASTDATE ( 'Table'[Date] ), -12, MONTH )
)

    Or you can refer to the following blog for more help:

    Trailing Twelve Months TTM Power BI, Prior TTM, Variance, DAX (p3adaptive.com)


    If the problem is still not resolved, please point out your specific questions and provide test data (delete sensitive information), I will answer you as soon as possible.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies