Forum Discussion
MoM% Calculation
hmm Ok, but that doesnt solve my problem to represnt data in a visual like below
However I found a work around by creating a different calendar table and making few measures.
Anonymous there seems to be an issue with the dates in your table. so keep it simple. i have created a seperate date table which will be used to filter the data from the main table.
i have also created calc column in the dimdate table like below
you can add more calc column as per your need in the dimdate table. Below is the result you were looking for
let me know if it works for you. thanks
Anonymous
i can see your formuala is slighly incorrect. You can create a measure like below
MoM Vol Change =
var cm_vol=CALCULATE([sales)],DATEADD('Calendar'[Date],0,MONTH))
var pm_vol = CALCULATE([sales],DATEADD('Calendar'[Date],-1,MONTH))
return
DIVIDE(cm_vol,pm_vol,0)
Its not giving me the correct output
If I get the previous Month MQR column correct then MoM% can be easily calculated but this column is not giving me correct values and I have almost tried every function. Not sure what the issue is.
I'm attaching link to the sample PBIX file.
Let me know in case you find any issue in the model.
https://drive.google.com/file/d/1jUark0E2v0z56RQjIeOZBERkrL7loHuC/view?usp=share_link
Hope this is the result you are looking for
Yes this is exactly what I'm looking for.
Kindly let me know how you calculated the previous month MQR?
