TAM between two dates

[Anonymous]

Hi guys,

I want to create a 12 TAM measure in my cube of SSAS in case of use it in my PowerBI report (or create a new measure in it).

I have a sales 'tFRA' and i want to see it in 12 past months accummulated.

Any idea?

Regards.

[vanessafvg]

@Anonymous what is a TAM measure?

when you say the last 12 months i am assuming you mean a rolling 12 months?  Also is this tabular SSAS or MDX?

you could do something like this (assuming you have a date table with its relationship mapped and its DAX you after)

TAM = 

Calculate(sum([tFRA]),

DATESBETWEEN('Date'[Date],
NEXTDAY(SAMEPERIODLASTYEAR (LASTDATE ('Date'[Date]))),
LASTDATE( 'Date'[Date])
)
)

[Anonymous]

Sorry i wanted to say MAT (Moving Annual Total), but in my case i want just 3 months, 6 months, etc

[Anonymous]

And there are tabular cubes, sorry again!

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Please take a look at the blog below about how to calculate Moving Annual Total, just use 3 months or 6 months instead of 1 year.

http://www.daxpatterns.com/time-patterns/

Regards,
Lydia Zhang