How to Calculate MoM Change Using Formula

  • 5 June 2024
  • 1 reply


Hi, I am trying to calculate the MoM change in a metric, I know there is an option of ‘Show Value As’, but that just creates a view on top of the existing numbers and does not perform a calculation on the cells. Is there a way I could do a MoM change using a formula? 




Best answer by CDALMAY 6 June 2024, 15:23

View original

1 reply

Userlevel 3
Badge +6

Hi @Moosa Malick,

Assuming your metric as the Month dimension since you want to perform MoM, you could do the following :

Metric/Metric[SELECT:Month-1] - 1

This metric will give you for each month the % Growth vs the Previous Month.

However, if that’s just for reporting, ‘Show Value As’ feature might be preferred especially when you do an aggregation.

Let me know if that helps