Forum Discussion

henryhuynhpham's avatar
henryhuynhpham
New Member
2 years ago
Solved

Month to Month Difference

I am doing a dashboard showing percentage score of each month for different elements. I am stuck at adding a comparision/different from this month to the previous month. For example, August's overall...
Need Help
  • Nilupul's avatar
    Nilupul
    2 years ago

    This is because Month column data type is not a date.
    You can try to change the Month column data type to Date in transform data option.
    Right click on the table particular table in Data section > go to edit query
    Select the month column
    Go to Transform tab in the top menu.
    change Data Type to “Date"

     

    Once change it, Click on File > Close and Apply


    After that try to create the measure.

Nilupul's avatar
Nilupul
Frequent Visitor
2 years ago

You can try below measure to calculate the diffrence between months.

 

Overall Score Diffrence = 
VAR _CurrentMonthScore = SUM('Table'[Score])
VAR _PrevMonthScore =
CALCULATE(SUM('Table'[Score]),PREVIOUSMONTH('Table'[Month]))

RETURN
_CurrentMonthScore - _PrevMonthScore

 

 

  • henryhuynhpham's avatar
    henryhuynhpham
    New Member
    2 years ago

    It gave me this error.

     

    • Nilupul's avatar
      Nilupul
      Frequent Visitor
      2 years ago

      This is because Month column data type is not a date.
      You can try to change the Month column data type to Date in transform data option.
      Right click on the table particular table in Data section > go to edit query
      Select the month column
      Go to Transform tab in the top menu.
      change Data Type to “Date"

       

      Once change it, Click on File > Close and Apply


      After that try to create the measure.

      • henryhuynhpham's avatar
        henryhuynhpham
        New Member
        2 years ago

        Thank you for the formula!