How to extract only unique text from a column?

[Anonymous]

Ex: Apple,Orange, Grapes, Apple, Apple, Orange 

To be extracted as Apple, Orange, Grapes

[v-xuding-msft]

Hi @Anonymous ,

Please see the gif. It shows the two ways. One is using M language in the Query Editor. Another is using DAX.  If they are not what you want, please share more sample data and your expected results. Then we will understand clearly.

Best Regards,

Xue Ding

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

[trebgatte]

It depends on what you want to do with this data afterward. You could use the technique documented here: https://marqueeinsights.com/how-to-work-with-sharepoint-multi-value-columns-in-power-bi/

This would give you a way to filter on all records that contain Apple, for example.

--Treb, Power BI MVP

Check out our Power BI blog posts at https://marqueeinsights.com/category/power-bi/

[AnthonyTilley]

Go to the modeling Tab

Select New Table

in the formula bar create a table as follows

Unique Values = DISTINCT('Table'[Colunm])

[Anonymous]

Hi thanks for your support.

But this formula does not work in query editor.

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @Anonymous ,

Do you try my way and check that sample?

= Table.Distinct(Source)

If that not what you want, can you please share some sample and your expected results. Then we will understand clearly.

Best Regards,

Xue Ding

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