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
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?
I have used the measure that you already created. However, in the visualization, instead of Month_year column, I have used the Year & Month from the date hierarchy of the FULL_DATE column
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