Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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... ...
Need Help
  • alena2k's avatar
    alena2k
    4 years ago

    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.

alena2k's avatar
alena2k
Resolver IV
4 years ago

I am sorry that I confused you. I was trying to offer solution without DAX. Power Query allows you to prepare data for visualizaiton and avoid complex measures.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    OK, all i see is DAX code so not sure how to interpret that as being a wisiwig solution.

    I've responded with a link to a small PBIX file with the data shown in my OP if you would like to put the solution there and save (I've made anyone with the link able to edit the file.