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

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!