Skip to main content

Hi Pigment community,

I want to realise a LTM (Last Twelves Months) analysis for a metric.

For the moment, I’m able to cumulate only by the beginning of the period with the function:

CUMULATE(Revenues,Month)
/Filter: Month.Year = Year."FY 22" OR Month.Year = Year."FY 23" OR Month.Year = Year."FY 21"]

I can make it “restart” each year with using CUMULATE(Revenues,Month,Month.Year) but I want to cumulate the last 12 Months only

LTM Revenue Feb 22 should be starting from Feb 21 and not Jan 21.

How can I do that?

Many thanks

Hi Ahmed,

You can try the movingsum() function

 

That should look like something like this:

 

Hope it helps.

 

Best,

Benoit

 

 

 

 


Hi Benoit,

 

Many thanks for the answer, very helpful!!

 

Have a good day,


Reply