Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |