cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MPinfo
Helper I
Helper I

Choose on value of column

Hello Everyone.

 

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

 

Example :

 

MPinfo_0-1637661067482.png

 

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

 

Thank you for you help ! 

5 REPLIES 5
v-xiaotang
Community Support
Community Support

Hi @MPinfo 

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.

vxiaotang_0-1637909815796.png

vxiaotang_1-1637909823734.png

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
Solution Sage
Solution Sage

@MPinfo ,

 

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





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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

MPinfo_0-1637662548873.png

 

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

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





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@MPinfo , 

 

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





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors