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



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

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



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

Helpful resources

Announcements
Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.