Forum Discussion
Previous Measure
Hi I am trying to return previous year quarter value but only for one value it is not returning other than that everything is showing correct Hi I am trying to fix promote prev measure t...
Hi, Anonymous
Based on your description, I've created the following sample data:
Create the following three measures:
Promote cuff measure = SUM('Table'[Promote cuff]) Promote prev = CALCULATE([Promote cuff measure],OFFSET(-1,ALLSELECTED('Table'[Year Quarter],'Table'[Tax distribution]))) Promote diff = [Promote cuff measure] - [Promote prev]Put it in the table visual:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Try using
dax
Promote curr = CALCULATE(MAX('Promote Breakdown'[Promote (incl Tax Advances) new]))
Promote Prev =
VAR CurrentPeriod = MAX('Date'[Period])
VAR PreviousYearPeriod = CurrentPeriod - 4
VAR PrevValue =
CALCULATE(
[Promote curr],
FILTER(
ALL('Date'),
'Date'[Period] = PreviousYearPeriod
)
)
RETURN
IF(
ISBLANK(PrevValue),
0,
PrevValue
)
Hi IT IS showing 0 for all feilds