topic Re: Dax : I want to write Dax measure % increase or decrease versus pervious month in DAX Commands and Tips

Dax : I want to write Dax measure % increase or decrease versus pervious month

SupriyaVarun — Tue, 11 Jul 2023 06:15:34 GMT

Hi Everyone,

Can you please help with Dax, I am using a Live connection and I have to Write Dax measure for the Actuals

For Fiscal month.

I want the output like this below

Jan = 0%

Feb = 15.3% -18.7% = -3.4%

Mar = 16.1% -15.3% = 0.8%

Thank you

Re: Dax : I want to write Dax measure % increase or decrease versus pervious month

tamerj1 — Tue, 11 Jul 2023 07:53:24 GMT

Hi SupriyaVarun
The assumption is that your date table contains a YearMonthRank column which is a squential number that increases by one every month over the years.

Actual MOM = VAR CurrentAcual = [Actual] VAR PreviousActual = CALCULATE ( [Actual], ALLSELECTED ( 'Date' ), 'Date'[YearMonthRank] = MAX ( 'Date'[YearMonthRank] ) - 1 ) RETURN CurrentAcual - COALESCE ( PreviousActual, CurrentAcual )

Re: Dax : I want to write Dax measure % increase or decrease versus pervious month

SupriyaVarun — Tue, 11 Jul 2023 09:03:13 GMT

Hi Tamerj,

Thanks a lot for the help 🙂 It worked

% Automated Order EU - Previous Month =
VAR CurrentAcual = [% Automated order EU]
VAR PreviousActual =
CALCULATE (
[% Automated order EU],
ALLSELECTED ( 'SM Dim Calendar' ),
'SM Dim Calendar'[Fiscal Month Number]
= MAX ( 'SM Dim Calendar'[Fiscal Month Number] ) - 1
)
RETURN
CurrentAcual - COALESCE ( PreviousActual, CurrentAcual )

Re: Dax : I want to write Dax measure % increase or decrease versus pervious month

SupriyaVarun — Wed, 19 Jul 2023 14:32:24 GMT

Hi tamerj1 ,

For the below query how to hide the Future months eg : Aug month showing the -44.6% now I want it to show blank

Thanks in advance