Choose on value of column

[Anonymous]

Hello Everyone.

I got 4 data with some differences, i want to select just one value.

Example :

The last column got several value, i just want one of them.

Thank you for you help ! 

[v-xiaotang]

Hi @Anonymous 

Which value do you want to keep? Does it have a rule?

Besides, if you want to split values in a cell, you can use Split function.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

[manikumar34]

@Anonymous ,

Use either First or Last value on the last column or conctenate those 3 values into one with a separator by usning CONCATENATEX

[Anonymous]

I Try with the first on last, but i got a value totally different like, for example : 

How can i concanetex if i don't have a separator for this ?

[manikumar34]

I see you have removed 4th column on above image. On firrst image I can see 5 columns,

[manikumar34]

@Anonymous , 

Separator can be passes on CONCATENATEX function like ","(comma as a separator),
Refre belo link. 

https://radacad.com/concatenatex-in-power-bi-and-dax-concatenate-values-of-a-column