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 = 15.3% -18.7%  = -3.4% 

Mar = 16.1% -15.3% = 0.8%

 

Thank you 

I 

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

3 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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 )
    • SupriyaVarun's avatar
      SupriyaVarun
      Frequent Visitor
      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