topic Re: distinct values from existing column power bi dax in DAX Commands and Tips

distinct values from existing column power bi dax

Anonymous — Mon, 15 Jan 2024 18:07:32 GMT

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.

Re: distinct values from existing column power bi dax

Greg_Deckler — Mon, 15 Jan 2024 18:58:48 GMT

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.

Re: distinct values from existing column power bi dax

Anonymous — Wed, 17 Jan 2024 08:53:31 GMT

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.