Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Vandergledison
Helper III
Helper III

Measure that extracts Text from a Column

Hi everyone,

I have a column that contains the customer names.

I need to create an IF measure where i will give numbers to these customers depending on their names.

I cant use the if or switch functions directly. Is there a way to create a simple measure that extracts the customer names from a column?

thanks 

VG

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @Vandergledison ,

 

You can use DISTINCT function for it. However maybe is better to transform it on Power Query.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
camargos88
Community Champion
Community Champion

Hi @Vandergledison ,

 

You can use DISTINCT function for it. However maybe is better to transform it on Power Query.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Hi @camargos88 ,

thanks a lot, it was exactly what i needed it. Why do you say that would be better via power query?

thanks

Hi @Vandergledison ,

 

I said it in case you don't use your original column.

Also it depends on your model size, if small amount of data shouldn't impact anything.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.