Forum Discussion
undefined
I have ID column the formate of it is Text, and ID column has many repetead ID's, I wan to cleare a new column with only distinct ID's. Thanks in Advance
You have to get a new table
New table = distinct(table[Column])
You can join your table as dimension
Hi Anonymous ,
You can try to create a new table:Table2 = DISTINCT('table'[id])
If necessary, you can also create a relationship for the two tables based on the ID.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.