Forum Discussion
MoM% Growth showing value as zero
Hi, I want to create MOM growth of FTE_Name (has null values) being authenticated. Here are my Dax measures : CurrentMonthFTE1 = CALCULATE( COUNTROWS('IPAReportMonthwise'), NOT(...
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 .
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.