Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum all comtens in multiple columns

Hi everyone im new in powerbi and Dax funtions I trying to merge or sum all contents in multiple columns the divide from total of participants all the participants has multiple answers Like the nex...
  • Fowmy's avatar
    5 years ago

    Anonymous 

    You can unpivot the table in Power Query and the rest is easy. Please find attached the Power BI file below my signatire.

     

  • CNENFRNL's avatar
    5 years ago

    Anonymous , first of all, you might want to try transforming the dataset into a flat table,

    then, you can author different measures to conduct different analyses.