MoM% Growth showing value as zero

[Anonymous]

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(ISBLANK('IPAReportMonthwise'[FTE_Name])),

    USERELATIONSHIP('IPAReportMonthwise'[LogstoFetchArenaUsersMonthwise.AuthDate], 'DateTable'[Date])

)

PreMonthMeasure1 =

CALCULATE(

    COUNTROWS('IPAReportMonthwise'),

    NOT(ISBLANK('IPAReportMonthwise'[FTE_Name])),

    USERELATIONSHIP('IPAReportMonthwise'[LogstoFetchArenaUsersMonthwise.AuthDate], 'DateTable'[Date]),

    PARALLELPERIOD('DateTable'[Date], -1, MONTH)

)

MoMGrowth1 =

DIVIDE(

    [CurrentMonthFTE1] - [PreMonthMeasure1],

    [PreMonthMeasure1],

    0

) * 100

Here is the output showing same results for CurrentFTEUsers and PreMonthUsers and MomGrowth as 0.

[Corey_M · Accepted solution]

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.

[Anonymous · Accepted solution]

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 @Corey_M .

  

[Corey_M]

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 

[Anonymous]

I know, I have tried parallelperiod and other solutions too but all showing same values.

[Corey_M · Accepted solution]

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.