Power Platform Community Forum Thread Details

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

Categories:

Power Query

Community site session details

Automatic Custom Columns with YTD Calculation

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates