The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi, as the title suggests I'm looking to populate a column in a new table with distinct values from a column in an existing table.
For example, Table1, Column1 = {1, 2, 2, 3, 4, 4, 5}
Should look like NewTable, NewColumn = {1, 2, 3, 4, 5}
Solved! Go to Solution.
Please try
Table2 = DISTINCT(Table1[Column1])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Anonymous - Should be:
NewTable = DISTINCT(SELECTCOLUMNS('Table1',"NewColumn",[Column1]))
Hello! Are you able to adapt this formula to create a new column with unique values from two other columns? Say,
NewTable = DISTINCT(SELECTCOLUMNS('Table1',"NewColumn",{[Column1],[Column2]})
Or something to that effect?
Please try
Table2 = DISTINCT(Table1[Column1])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Where do I enter this code?
@Anonymous -
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |