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])



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

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])



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

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!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.