Unpivoting a calculated table

Question

Hi, I created this calculated table which contains, as columns, measures created that represent different KPIs of machine learning models.

The table is grouped by model and by month.

What i want to do is to convert the last 4 for columns into one column that contains the 4 measures.

Thank you for the answer!

amitchandak · Answer

tomasbaleriani , What do mean by one column? you can concatenatelike 
&nbsp;
"all 4" , [M1] &amp; "," &amp; [M2] &amp; "," &amp; [M3] &amp; "," &amp; [M4]
&nbsp;
Please Note : Calculated Table columns coming measure will not change because of the slicer. They will be static

tomasbaleriani · Answer

Thanks for the response, I think i am not being clear.&nbsp;&nbsp;I have this table that i have created with summarize&nbsp;ML Model|Month|Measure 1|Measure 2|Measure 3&nbsp; Port IN&nbsp; &nbsp; &nbsp;JAN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X3&nbsp;What I want to do is..ML Model | Month | New Column | New Column&nbsp; &nbsp;Port IN&nbsp; &nbsp; &nbsp; JAN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Measure 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X1&nbsp; &nbsp;Port IN&nbsp; &nbsp; &nbsp; JAN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Measure 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X2&nbsp; &nbsp;Port IN&nbsp; &nbsp; &nbsp; JAN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Measure 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X3

Forum Discussion

Unpivoting a calculated table

2 Replies

Related content

Pivot / Unpivot?

Unpivot Column

Unpivot Question

Unpivot Columns of Calculated Table

Unpivot