Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to summarize data in multiple columns

I have 15 columns named [event1] through [event15]. In each column, the user selected an item from a dropdown (in the database). The list of items is exacly the same for every event. So, [event1] , [...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Maybe you can consider to use unpivot columns feature to merge these fields, then you can simply use formula to summary multiple attribute fields based on condition

    Unpivot Data Using Excel Power Query

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

Maybe you can consider to use unpivot columns feature to merge these fields, then you can simply use formula to summary multiple attribute fields based on condition

Unpivot Data Using Excel Power Query

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Anonymous wrote:

Hi Anonymous ,

Maybe you can consider to use unpivot columns feature to merge these fields, then you can simply use formula to summary multiple attribute fields based on condition

Unpivot Data Using Excel Power Query

Regards,

Xiaoxin Sheng

I actually was able to do the Unpivot in Power Bi. It works like a charm! Thank you so much!