Forum Discussion
Solved
MAT
Hi all I want to calcuate the last 12 month Moving Annual totals, which i am using the following which is working. What i am struggling with is a measure or comparrision against the same period las...
For that one you can put in the IF ( ISBLANK () from your original:
Mat Volumn 12 = VAR _DateEnd = LASTDATE ( VRS[VRS Date] ) RETURN IF ( ISBLANK ( [Net Sales] ), BLANK(), CALCULATE ( [Net Sales], ALL ( VRS ), DATESINPERIOD ( VRS[VRS Date], _DateEnd, -12, MONTH ) ) )
Change the ALL ( VRS ) to ALL ( VRS[VRS Date] ) which should repect the other filters.
thank you so much..... you hero status in my office at the moment!!