Forum Discussion

RaMahi's avatar
RaMahi
Regular Visitor
3 months ago
Solved

MoM calculation

Hi Team, I need to calculate the previous month's score so that when a month is selected from the slicer, the conrresponding previous month's score is displayed against each country. Interim score_...
MoM calculation
  • krishnakanth240's avatar
    krishnakanth240
    2 months ago

    Hi RaMahi 

    As you have the measures for Current month(Interim score_avg) and Previous month(Interim score_avg PM) based on the Month difference you can show the arrow directions

    MoM Change = [Interim score_avg] - [Interim score_avg PM]


    MoM Arrow =
    SWITCH(
    TRUE(),
    [MoM Change] > 0, "▲",
    [MoM Change] < 0, "▼",
    "-")

     

RaMahi's avatar
RaMahi
Regular Visitor
2 months ago

Hello Shai_Karmani ,

Thanks for the solution.

However This solution is showing the last month's scorem but when I select a date from the slicer, it become Blank. Could you please suggest a solution for this?

 

Actually, I want to display an up/down arrow in the "Interim score_avg" column, which is why i am considering this solution.

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
2 months ago

Hi RaMahi 

As you have the measures for Current month(Interim score_avg) and Previous month(Interim score_avg PM) based on the Month difference you can show the arrow directions

MoM Change = [Interim score_avg] - [Interim score_avg PM]


MoM Arrow =
SWITCH(
TRUE(),
[MoM Change] > 0, "▲",
[MoM Change] < 0, "▼",
"-")