topic Previous Measure in DAX Commands and Tips

Previous Measure

Anonymous — Fri, 14 Feb 2025 10:55:42 GMT

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 the logic is it should take values from previous year quarter
For example 2025/q4 is 8772498 that value is showing 2026/q4 but 2027 q4 16538747 is not showing 2028/q1

and it is segregated as tax distribution and promote values

I am pasting expected output

I am pasting the dax which i used to achive this promote prev

Promote curr = CALCULATE(MAX('Promote Breakdown'[Promote (incl Tax Advances) new]))

Promote Prev =

VAR PrevValue =

CALCULATE(

[Promote curr],

FILTER(

ALL('Date'),

'Date'[Period] < MAX('Date'[Period])

)

RETURN

IF(

ISBLANK(PrevValue),

PrevValue

)

VAR PrevValue =

CALCULATE(

MAX('Promote Breakdown'[Promote (incl Tax Advances)]),

FILTER(

ALL('Date'),

'Date'[Period] < MAX('Date'[Period])

)

RETURN

IF(

ISBLANK(PrevValue),

PrevValue

)

Hi guys please suggest the issues or kindly help me to achive this

Re: Previous Measure

bhanu_gautam — Fri, 14 Feb 2025 10:57:13 GMT

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
)

Re: Previous Measure

Anonymous — Fri, 14 Feb 2025 10:59:30 GMT

Hi IT IS showing 0 for all feilds

Re: Previous Measure

Anonymous — Mon, 17 Feb 2025 08:03:09 GMT

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.