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

Подписаться 48 тыс.

Просмотров 25 тыс.

50% 1

Get Demo Files here
ko-fi.com/s/af...
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!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 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 RU-vid.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.micros...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@danelemon5959 2 месяца назад

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?

@Q1ller Год назад

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

@fernandogabriel8452 Год назад

Solved my problem! Thanks!!

@anim57 2 года назад

Thanks!

@SolutionsAbroad 2 года назад

You're very welcome, thanks for the tip!

@ronniepatel5672 Год назад

Thank you

@danishnawaz3651 7 месяцев назад

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.

@tusharmestry01 Год назад

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?

@ennykraft 2 года назад

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.

@user-hm8wm5ro7q 9 месяцев назад

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.

@sabkuchdhela191 2 года назад

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

@abdulqadeerkamangar6279 3 года назад

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

@SolutionsAbroad 2 года назад

hi, I've never done it like that, as far as I know it has to be scalar values in these expected results, hope that helps

@rubenmorettimontoya2489 2 года назад

Did you find a way? I have the same task to complete and it seems very usefull to know

@abdulqadeerkamangar6279 2 года назад

@@rubenmorettimontoya2489 sorry i havent tried that string.

@vangelaobli Год назад

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

@benjison1000 2 года назад

How about using containsstring w/ a measure?

@SolutionsAbroad 2 года назад

Hi Ben, its possible but you'll need to provide a context with the measure since it won't have one

@nikhilramachandran9351 2 года назад

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

@SolutionsAbroad 2 года назад

Hi, can you expand on your issue? You need two values for the containsstring to work

@noahsitu8126 2 года назад

@@SolutionsAbroad Hey I have similiar qurstions. like what if I want to check if this column have the same values in another column? Like a cross match. and display the unique values among those two columns

@tusharmestry01 Год назад

@@noahsitu8126 after containsstring use selected value for selecting column