Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.