Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, everyone,
I am looking for a solution to the following problem: How can I convert a column of a table into a list without destroying the base table? The base table should continue to exist in the data model. Then i would like to create another new table from the list
Many Thanks Nick
Solved! Go to Solution.
Let's say your base table is named "BaseTable". You can add a blank query, and then in the formula bar, type:
= BaseTable[ColumnName]
That gives you the list. You can wrap it in Table.Distinct to get unique values. If you want it as a one column table, it's:
BaseTable[[ColumnName]]
--Nate
wow, thank you very much 🙂 I've tried so much and then it's so easy - thank you
Nick
Let's say your base table is named "BaseTable". You can add a blank query, and then in the formula bar, type:
= BaseTable[ColumnName]
That gives you the list. You can wrap it in Table.Distinct to get unique values. If you want it as a one column table, it's:
BaseTable[[ColumnName]]
--Nate