How to get comparisons week on week accurately

[Anonymous]

Hi,

I have an issue where I get weekly data that which I import. There is a core ID in the data but the rest as too many cooks means descriptions further down are changed too much. So the data when trying to compare week on week does not use the unique id but sees two different entry.

I cant compare week on week or going back on a detailed level which I would like to do. 

I dont know how to fix this.

Can someone help

[NikhilChenna]

Hi @Anonymous ,

Please refer the below link i think you are looking for a similar solution,

https://community.powerbi.com/t5/Desktop/week-on-week-comparison/m-p/2535171

https://community.powerbi.com/t5/Desktop/Week-over-Week-Comparison/m-p/298471

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Anonymous]

I can get the overall number week on week correct, its at the detail level it goes wrong. You see people delete things and add for same ID and the table is not clever enough to do automatically

as u can see above