Forum Discussion

bidgeir's avatar
bidgeir
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Calculating plan accuracy, circular reference

Hi all   I´m trying to calculate plan accuracy where I can "use" orders from +-1 week to fulfill the plan. As you can see in the image below I have 13 weeks. In those 13 weeks I have plan in column...
DAX
Power Query
bidgeir's avatar
bidgeir
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

I have created a PBIX with the Excel imported if anyone prefers not to import then Excel data. You can find the PBIX here: https://tinyurl.com/yutx7st9