distinct values from existing column power bi dax

[Anonymous]

HI Team,

I am trying to create new table  with  distinct values from existing column using these formula : values(table[column] but getting duplicate values .

can you help on the same?

Power bi file link : distinct.pbix

Thanks,

Deva.

[Anonymous]

Hi @Anonymous ,

I can't access your pbix file, please change the permissions and re-share.
As @Greg_Deckler  said, you can use DISTINCT() function. Please check your data for spaces. You can add a custom column to check the character length.

You can de-dupe the columns in power query.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Greg_Deckler · Accepted solution]

@Anonymous Well, I would use DISTINCT instead of VALUES or ALL used with a column also produces distinct results oddly enough. But, if you are getting duplicate values that's likely trailing whitespace or hidden characters causing it or something along those lines. Add some trim and clean operations in Power Query Editor.