mom calculation
1 TopicMoM 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_avg is a measure which is calculated as below: Interim score_avg = AVERAGEX(VALUES(E1[MMYYYY]),CALCULATE(SUM(E1[Interim Score (A*B)])))Solved1.2KViews2likes6Comments