Forum Discussion
MoM% Growth showing value as zero
one suggestion I can think of is use something like a year-mo for from the date calendar table as the table's first column as opposed to a month from the table being summarized.
As suggested added year-mm column from the DATE table (I was taking it from IPAReportMonthwise table) and it worked as expected, Thanks a ton Anonymous .
Based on the image provided the issue is that your premonth measure and current month measure are returning the same value. and your month over month measure works correctly to give 0.
although I am not sure what your error is on the first 2 measures as they both look fine to me but you should see an offset like this
I know, I have tried parallelperiod and other solutions too but all showing same values.
one suggestion I can think of is use something like a year-mo for from the date calendar table as the table's first column as opposed to a month from the table being summarized.