Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

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(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],

) * 100

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

Anonymous
1 year ago
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
1 year ago
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 .

Anonymous
Not applicable
1 year ago
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
  Not applicable
  1 year ago
  I know, I have tried parallelperiod and other solutions too but all showing same values.
  - Anonymous
    Not applicable
    1 year ago
    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
Not applicable
1 year ago
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 .