Forum Discussion
tmears
Helper III
Helper IIIMAT
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 ) ) )
tmearsHelper III
Helper III
jdbuchanan71
Super User
Super UserFor 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 )
)
)
- tmears
jdbuchanan71you are a star, thank you so much!! Not sure if i can push my luck, i also need to do this calculation based upon the customer called buying group. but obviously if i bring in the 'buying group' it returns a total sum. the customer called buying group. but obviously if i bring in the 'buying group' it returns a total sum.
- jdbuchanan71
Change the ALL ( VRS ) to ALL ( VRS[VRS Date] ) which should repect the other filters.
- tmears
thank you so much..... you hero status in my office at the moment!!