Forum Discussion
Summarize values from variable fields based on year... is it even possible?
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.
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 am unable to open that file as it says that the file is incompatible with my version of PowerBI.
I have version 2.96.1061.0.
Are you using an older version?
Can you update your version and submit a newer version of the pbix file?