Forum Discussion
MoM calculation
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, "▼",
"-")
Super UserFor previous month time intelligence, you need a Date table with a real Date column marked as the date table, related to E1 on a Date column (not MMYYYY text). Once that is in place, this measure gives the previous month's score per country:
Interim score_avg PM =
CALCULATE(
[Interim score_avg],
DATEADD('Date'[Date], -1, MONTH)
)If E1 has a real date column you can use directly, the same DATEADD on E1's date will work. A marked Date table is cleaner because slicers on E1[MMYYYY] (text) cannot drive DATEADD; the shift has to happen on a real date column. Put your month slicer on the Date table so the row context for the previous month is unambiguous.
If that was helpful, please give a thumbs up and mark it as resolved.
Best,
Shai Karmani
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
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, "▼",
"-") 
Fenil_ItaliyaAdvocate I
Hello, RaMahi
Make sure that in your data there must be the data regarding the previous month, I mean when you select February,2026 then there is must be data regarding January,2026.
If there is no data regarding January 2026 then it return blank.
If this is not the issue then probable causes may be
you can create a datetable and Use it for time intelligence.
