How to "unpivot" data in a table based on calculated columns

[Rakel]

Hello,

I have a table with many columns. Based on those columns, I have created a set of calculated columns to get some alerts. 

The data is in a layout like this one (and more much fields):

and I need to unpivot these rows to get something like this: 

I've tried to unpivot it but the only way I know is on the load /transform step and there I don't have the calculated columns.

Can you please help me to get this? 

Thanks in advance,

        Raquel 

[Rakel]

Thank you very much for your help.

[amitchandak · Accepted solution]

@Rakel , if you have created those columns in DAX, you can not unpivot them. In power Query you can Unpivot, but column need to created in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

In dax you have to create a new table

union (

Summarize(Table ,Table[Contact Id], Table[Contact Name], Table1[Calculated COlumn 1]),

Summarize(Table ,Table[Contact Id], Table[Contact Name], Table1[Calculated COlumn 2]),

Summarize(Table ,Table[Contact Id], Table[Contact Name], Table1[Calculated COlumn 3]),

Summarize(Table ,Table[Contact Id], Table[Contact Name], Table1[Calculated COlumn 4]))