Log In
Register
Home
February 19, 2023
Offline
Dear All,
I have a TB, based on the recent month's data, it should calculate monthly movement automatically and movement from average.
For example:
Basic Principal:
If we are in M12 then it should calculate monthly movement between M12 and M11 and then calculate average from M1 till M11 and calculate movement from M12 and average automatically and dynamically using power query.
No matter in which month we are it should follow the above principle.
If we are in M4 then it should calculate monthly movement between M4 and M3 and then calculate average from M1 till M3 and calculate movement from M4 and average automatically and dynamically using power query.
Please see the attached file which have a tab called "Data" and the "Result I want".
Thanks for your help.
Moderators
January 31, 2022
Offline
I'm sorry but don't understand. The file has very little data and doesn't seem to correspond the the cell references you mention. Can you upload a file with some more realistic data please?
February 19, 2023
Offline
Hi,
Sorry for the confusion.
I have added few more rows into the "data tab". Also explained it more better in the tab "Result I want". I hope it will be quite clear now.
Many Thanks for your help.
Moderators
January 31, 2022
Offline
Please see attached in the PQ tab. Quite a few steps (split in separate queries), including changing the headings in the data table, and it probably can be streamlined a bit. Though I didn't go so far as it seems to do what you asked for. See if you can get it to work on your end and come back here if you get stuck.
1 Guest(s)
