TTM Calculation

[Anonymous]

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

[v-henryk-mstf · Accepted solution]

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.

[Greg_Deckler]

@Anonymous You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008