DAX Fridays!

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

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

50% 1

In today's video we will cover two new DAX functions released on the Power BI Desktop Update March 2019. The functions are CONTAINSSTRING and CONTAINSSTRINGEXACT. Enjoy!
#curbal #daxfridays #powerbi #dax
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!Here you can download all the pbix files: curbal.com/donwload-center
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
www.amazon.com/shop/curbal
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#daxfridays #curbal #dax #powerbi #mvp

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

14 мар 2019

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

5 лет назад

¡Excelente Ruth! gracias por la explicación.

@CurbalEN 5 лет назад

De nada y buen fin de semana! /Ruth

@gravanita 5 лет назад

Hi Ruth, I think there is a bit of confusion on what exactly is going on with the formulas you present. I say this because I was left with the feeling that you were expecting the rows to be treated as a list of words. That doesn't happen. If you remove the "selectedvalue" the formula will work the same (in the case presented). The test that is done is to check if "hors" exists on the whole string, and it does. The CONTAINSSTRINGEXACT from my point of view is working as expected.

@CurbalEN 5 лет назад

Thanks for the feedback! /Ruth

@stephenbrincat7124 5 лет назад

Hi Ruth, thanks as always.

@CurbalEN 5 лет назад

You welcome Stephen and thanks for all your support! /Ruth

@edududu504 5 лет назад

Agree! It's OK to have one function that's case sensitive and another that is not, but it would be great to have one simple function that search for exact words. Saludos y gracias por la clase!!

@CurbalEN 5 лет назад

De nada y buen fin de semana! /Ruth

@HachiAdachi 5 лет назад

I'm a bit surprised that DAX didn't already have these functions before. M has Text.Contains, so I guess I just assumed that DAX had a similar one (obviously I had never had to use it). Anyhow, it's good that we have them in our DAX toolbox now. Thanks, Ruth!

@CurbalEN 5 лет назад

No direct function, you had to use Search and Find and sumx to get something similar! The fact that you didn’t know is a good thing, meaning you were using Power Query for that ;) /Ruth

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

HELP: SQL has different LIKE operators with '%', for example: WHERE CustomerName LIKE 'a%'. Is there a similar funtion in DAX?

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

thansk

@PawanBaliwandererbali 4 года назад

Can we search by Selected Value (Input coming from Slicer) in a column that contains multiple texts. Returning True or False

@christopherhastings2142 5 лет назад

Great video! These functions look like they could be very useful when working with categorical data. I think that it is searching for if say "hors" is contained in the text. Try searching for "Hors" and it will not work.

@CurbalEN 5 лет назад

Yes!! They were indeed needed :) /Ruth

@PedroSanzLlorente 5 лет назад

hello Ruth, if the only difference is that one is case-sensitive and the other not, it could be simpler to have only one function with an additional paramer to select case or not case-sensitive.... it seems extrange to use 2 functions so similar.

@CurbalEN 5 лет назад

Yes, I agree with you. They could have that as an extra parameter and then create a true EXACT measure. That would be wonderful, thanks for sharing. /Ruth

@jochendecraene5519 4 года назад

Hello Ruth, Is it possible to write a DAX function using this "CONTAINSSTRING" where the "true" and "false" values are converted to 1 en -1?

@hello-u2w 4 года назад

WOW!!!!!!!!!!!!!!!!!!!!!!!!!!!

@CurbalEN 4 года назад

🥳🥳🥳

@brianxyz 5 лет назад

What would be really cool and really useful is if DAX and M had the search and replace functionality that Word has. Switches to indicate that you want an exact match, whole words only, ignore punctuation, ignore white space, etc. would be extremely powerful and they could wrap it all in one function for Containsstring and one for Find. They could get rid of Search or make Search have the exact same functionality as Find.

@CurbalEN 5 лет назад

That would be really amazing!! Who knows? Maybe soon :) /Ruth