I have a table with 4 CALCULATED cols:
Col1 Col2 Col3 Col4
Val1 Val2 Val3 Val4
Val5 Val6 Val7 Val8
I want to to create a new table with a single column which has values from Col2 and col3:
Is this possible?
Go to Solution.
Following the post of @jessicammoss
You can simplified this doing:
Create a New Table:
Table = UNION(VALUES(Table1[Col2]),VALUES(Table1[Col3]))
View solution in original post
@AGo in power bi desktop, go to query editor (Edit Queries) and highlight column col2 and col3 and under Transform tab click Unpivot Columnns. Then remove unwanted columns.
This is the query editor, it doesn't contain the calculated columns of Power BI Desktop.
Assuming a base table of "CalcColTable", and column names as described, I think this expression for a new table will work. I'm not sure if there's a way to refactor the expression and make it simpler, but it produces the right outcome.
NewTable = UNION(CALCULATETABLE(SELECTCOLUMNS(CalcColTable, "NewCol", CalcColTable[Col2])), SELECTCOLUMNS(CalcColTable, "NewCol", CalcColTable[Col3]))
Do you need help in Spanish? Check out our new Spanish community section.
Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.