How to use CONTAINS, CONTAINSSTRING and CONTAINSSTRINGEXACT DAX Functions in Power BI

Get Demo Files here

In this video were going to cover how you can use the CONTAINS function, as well as its other variations to perform string searches across your dataset.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[danelemon]

Thanks.
Your showing the way these functions work helped me accomplish something at my job, etc..

[thetruthlyeswithin]

Thank you! you made it very simple to understand. Are you able to do a video showing how to use this info in charts and how to separate other words in the string?

[Qller]

Great video. Your channel is easily one of the best I have found. Thank you!

[tusharmestry]

Can you help me for DAX for finding multiple matched string from one column in other column (not single String e.g. "Chai", & return matched data in new column?

[danishnawaz]

Sir, plz make video for below.
If
1 table has 9 column,
2 table has 10
and 3 table has 8 .
Then how can we make equal all column for all table.. like we want to insert dummy column for missing column in tables and make equal like 10 column for each table.

[sabkuchdhela]

if we want to select more than one string for the same table.. How to do that?

[ennykraft]

Great video! Thank you. But it's so annoying that the CONTAINSSTRING function is one of those not available in Power Pivot. My clients aren't willing to pay for and support another product from Microsoft.

[hmwmroq]

Have a question - is there a method to find the keywords within strings that could be in different order? For example, look for 'Alice Mutton' in two sentence strings, one contains 'Mutton_Alice', and another contains 'Alice Liddell', I only want to find the first match.

[vangelaobli]

How do you change the value of true or false to something else without creating new column?

[abdulqadeerkamangar]

Instead of typing each expected results, can we select another column from where we need multiple output?

[benjison]

How about using containsstring w/ a measure?

[nikhilramachandran]

containstring function doesnt take column name . I couldnt do that?? please help

[fincyphilip]

your fonts and tv resolution is very small