Problems with an week index in Power Query

Hi m_dekorte ,

This is very helpful for sure and thank you for the work you are putting in...! but I now have the same weeknumbers as my HRE ISO-Week column. I need these week numbers (with the actual date year) to create an weekindex (the same as my day / month / year index) but with the use  of column HRE ISO-week or your Custom ISO Week. Is that possible?

I also want to create a measure where I calculate this weeks turnover compared to last years (Custum Iso Week) turnover. Can you help me with that?

Beneath is for example the year (from date) and the HRE Iso week (or your Custum ISO week). I need to make a measure which shows me the difference. Week 32 untill 34 is than;

32 = - 11.834

33 = + 6.743

34 = + 9.880

It would be nice when I can show that beneath 2023 in the matrix or in a KPI card. Is it possible to use a time intelligence function for that?

Thanks in advance!