% of change based on previous record

[Anonymous]

Hi All,

I have a ID , Date and Count of Records Column in my data set.

Provided my dataset Below

I would like to have a measure which tell the % of Change, for eg. for ID 147005 - we have count of records =10 on 03/01/2021 and then the record counts decreased to 5 on 05/01/2021 so it got decreased by 50%.

Provided the expected Output below

Please help me on this to achieve the change of % in this scenario. Thanks in Advance.

Regards,

Prakash M

[aj1973 · Accepted solution]

Hi @Anonymous 

Here is an example

https://drive.google.com/file/d/1bayrdoRurGndVhihjRYZBYNorIPYNjLH/view?usp=sharing

[goncalogeraldes]

Hi there, please refer to the post by  @v-ljerr-msft regarding this subject! It may provide you with a solution.

https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-change-from-prior-date-prior-re...

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes