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
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