cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shaglok
Frequent Visitor

Question about Find and Qlik's wildmatch.

I have a doubt, probably similar to this one: Solved: Qliksense Wildmatch -> Power BI DAX - Microsoft Power BI Community

 

I looked at the answers there, but could not find how to manage it exactly. In Qlik with the command:

if(wildmatch(Product, 'Altus Mod'), 'Altus Mod'

 

It searches the text "Altus Mod" in the Product field and loads it as "Altus Mod". That's very useful when we have fields with lots of information and we need to extract some. How can I do it with DAX? In Qlik it is used in the load, is there anything similar in Power Query?

 

Thank you.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Shaglok , Based on what I got

 

You need to create a column

 

if( search("Altus Mod",[Product],,0) >0 , "Altus Mod", [Product])

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @Shaglok,

You can take a look at the following blog to know about the string comparisons in Dax:

From SQL to DAX: String Comparison 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@Shaglok , Based on what I got

 

You need to create a column

 

if( search("Altus Mod",[Product],,0) >0 , "Altus Mod", [Product])

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.