Forum Discussion

RaMahi's avatar
RaMahi
Regular Visitor
2 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, "▼",
    "-")

     

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

RaMahi 
You need to add DAX measure like dateadd, that will calculate the previous month but you need to have proper date table in your data model, then you can build the calculation, as an example similar to following DAX measure will help you to achiveve the goal.

  

Previous month score=CALCULATE([Interim score_avg],DATEADD('DateTable'[Date],-1,MONTH)

This will:

Respect the selected country.

When June 2026 is selected, return May 2026's score.

When displayed in a matrix by country, show the previous month's score for each country.


If this helps, ✓ Mark as Kudos | Help Others