Forum Discussion

SupriyaVarun's avatar
SupriyaVarun
Frequent Visitor
3 years ago
Solved

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

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 = 1...
  • SupriyaVarun's avatar
    SupriyaVarun
    3 years ago

    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 )

SupriyaVarun's avatar
SupriyaVarun
Frequent Visitor
3 years ago

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

 

 

% 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 )

 

Thanks in advance