Forum Discussion

uscutieda's avatar
uscutieda
Frequent Visitor
2 years ago

How to summarize/unpivot columns in Power BI using DAX

Hello,

I'l like to use DAX to summarize the columns of Table1 into 3 columns like Table2. Unfortunatly the Contribution Columns in Table1 are calculated columns, so I can't use Power Query.

Thank you in advance

Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi uscutieda 

     

    Since you mentioned the "Contribute" column as a calculated column, I would suggest you to do the unpivot operation first and then add the calculated column.

     

    To help you solve the problem, it is best to provide the pbix file and carefully delete sensitive data.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.