Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Largest Change from Previous month HELP

Hi team,   I'm trying to create a visual that shows the top 5 variables in a specific column that experienced the largest change since the previous month. So as we add data on a monthly basis, I wo...
change
DAX
Visual
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI there,

     

    Thank you for offering a solution.

     

    I am trying to get the Top N relative changes , not absolute changes. So both your solution and my current one is showing absolute changes. E.g. X1 = 1000 , X2 = 3000 ; A1 = 200 A2 = 1000 . The larger relative change from month 1 to 2 happened to variable A not Variable X, but the current solution would show X above A in a table for instance. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Just to add I have created a new measure which calculates the total for each column but only for the latest month: 

       

      Current Month  = TOTALMTD(COUNTROWS('CLIENT DATASET'), 'CLIENT DATASET'[Dates] )
       
      I have tried to create a similar measure for the previous month, but the output on any visual is always blank:
       
      Previous month Count = CALCULATE( COUNTROWS('CLIENT DATASET') , PREVIOUSMONTH('CLIENT DATASET'[Dates]))
       
      Any reasons why this is?