Forum Discussion
Summarize values from variable fields based on year... is it even possible?
Below are 2 tables for examples. Top table has example raw data and bottom table is 1 possible way to demonstrate my desired outcome. Each Project has 5 yrs of budget for different categories... ...
Let's give it another try, still without DAX.
Please download this version of pbx file, open Power Query editor and look at data transformation for the Table(2). It uses your source data, unpivots them so Category can be unlimited and adds Year column for summarizing by year. Year is relative to the Year_1.
Table(2) is used for Matrix visual. I hope this helps.
I was able to open the file on my personal PC, save it and then open on my work PC.
Thank you for the solution. I think I will be able to duplicate the transformations on my real world data.