How to summarize/unpivot columns in Power BI using DAX

[uscutieda]

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

[Anonymous]

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.