Feb 14 2021 08:27 AM
Feb 15 2021 02:13 AM
I'm not a specialist in Power Query ... some also mean in general :)))
Here is the information from Microsoft that could possibly help you in your plans.
Add and rearrange fields in the Field List
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Feb 15 2021 08:08 AM
It looks like you need to add data to data model (if your version of Excel supports it) creating the Pivot Table and add DAX measure which calculates % to average in previous week. Without sample file it's hard to say something more concrete.
Apr 21 2022 10:52 AM - edited Apr 21 2022 10:53 AM
I have the same issue, where i want to calculate a deviation from all months, but i dont want it to be a column for each month, i only need one column that can show the total value based on all available months displayed in the table