How to calculate change in % in Cohort Analysis

[shanipowerbi]

Hi Power Bi Family

Hope you all are fine and health. This is my second post about same question. Actually I am trying to calculate Percentage of change in my cohort Analysis table.

I have period 1 to 12  and Conversion coversion month. like blow image. (Below table shows you the % of change in customer bucket).

I have correct manage to calcuate this table but unable to calculate this Red %, which is change as compare to last period.

Will you guys please help me to get this %.

Regards

Zeeshan

[jstorm]

From what I understand, you need to divide the number in the current column by the preceding column.  Your columns appear to be months. Based on these assumptions, you can try the following:

DIVIDE( [Activity Count],
    CALCULATE( [Activity Count], DATEADD( 'Date Table'[Dates] ), -1, MONTH) )
)

This divides the numerator [activity count] by the denominator [activity count] last month.  If your periods are not months, just change the MONTH part of DATEADD().

[shanipowerbi]

Thanks for the repy, for period I have use this formula

Period = DATEDIFF('Invoice Data'[User with Conversion Data.ConversionDate],'Invoice Data'[InvoiceDate],MONTH)

, If I can get previous perid number it wil be easy for me. 

[jstorm]

I see, then you should be able to use

DIVIDE( [Activity Count],
    CALCULATE( [Activity Count], [Period] - 1 )
)