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
6 Replies
You have to get a new table
New table = distinct(table[Column])
You can join your table as dimension
You need to create a new table instead of new measure or column. Click new table on modeling tab.
Unique ID = Distinct('sheet1'(IDcolumn))
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.Anonymous ,
Create new column with below DAX:
Distinct ID = CALCULATE(DISTINCT(table[IDcolumn]))
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.
Anonymous ,
So, create a new table and use DISTINCT('Table'[IDcolumn]).
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.
