How to calculate the change in % in cohort analysis

[shanipowerbi]

Hi Power Bi Family

I hope everyone's in good and healthy. This is my second post about the same question. I'm actually trying to calculate Percentage change in my cohort analysis table.

I have the period 1 to 12 and the month of the conversion coversion. as a blowing image. (The following table shows the % change in the client bucket).

I have the correct ability to trace this table, but I can't calculate this red %, which is the change compared to the last period.

Please help me get this %.

Best regards

Zeeshan

[v-xicai]

Hi  @shanipowerbi  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[shanipowerbi]

Hi

Your Formula is not worked for me

Thanks for the effort, Issue not yet resolve

[v-xicai]

Hi @shanipowerbi ,

You may create measure like DAX below.

% Change=

Var LastPeriod=  CALCULATE(SUM('Invoice Data'[UserID Count]),FILTER(ALLSELECTED('Invoice Data'),'Invoice Data'[Year]=MAX('Invoice Data'[Year]) &&'Invoice Data'[My]=MAX('Invoice Data'[My])&&'Invoice Data'[Period]=MAX('Invoice Data'[Period])-1))

Var CurrentPeriod=  CALCULATE(SUM('Invoice Data'[UserID Count]),FILTER(ALLSELECTED('Invoice Data'),'Invoice Data'[Year]=MAX('Invoice Data'[Year]) &&'Invoice Data'[My]=MAX('Invoice Data'[My])&&'Invoice Data'[Period]=MAX('Invoice Data'[Period])))

Return

IF(LastPeriod <> BLANK(), DIVIDE(CurrentPeriod, LastPeriod )-1, 0)

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shebr]

Hi @shanipowerbi 

How have you imported the data into Power BI? Meaning what tranformations have you applied? Can you share an extract of your data as this will help.

Thanks

Shebr

[shanipowerbi]

I've already heated this board and during the period I used

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

Now I need a change

My column will look like this

Year	My	UserID Count	Period
2019	January	1155	0
2019	January	1110	1
2019	January	1052	2
2019	January	1001	3
2019	January	958	4
2019	January	919	5
2019	January	883	6
2019	January	857	7
2019	January	838	8
2019	January	823	9
2019	January	807	10
2019	January	794	11
2019	January	777	12
2019	January	757	13
2019	January	744	14
2019	January	729	15
2019	February	1240	0
2019	February	1196	1
2019	February	1113	2
2019	February	1070	3
2019	February	1032	4
2019	February	994	5
2019	February	969	6
2019	February	944	7
2019	February	921	8
2019	February	896	9
2019	February	879	10
2019	February	852	11
2019	February	842	12
2019	February	823	13
2019	February	811	14