Hi,
I am enclosing an Excel file with a Table from a Power Query instance I am working on.
The Table shows figures of following fields combinations:
- CATEGORY (Frames, Lenses)
- SUPPLIER (Supplier 1, Supplier 2)
- CLASS (A, B)
- AGGREGATE (Sell-Out, Sell-In)
- MONTHS (from January to June)
The Table derives from a Query and the database is supposed to be updated each month.
What I am trying to achieve, but I am unable to, is to create a custom column with the YTD calculation for each single month.
In this example, being the months 6 (From Jan to Jun) there should be 6 additional columns as follows:
- YTD January (equals to January naturally)
- YTD February
- YTD March
- ... and so on
calculating YTD for each combination Category/Supplier/Class/Aggregate
and naturally once the query is refreshed after updating the database, columns shall upgrade too considering the number of months inside the database.
Can you please help me?
Thank you
Mark