How and When to Use CONTAINS, CONTAINSROW, CONTAINSSTRING and CONTAINSSTRINGEXACT in DAX

preview_player
Показать описание
In this tutorial, I'll be walking you through 4 DAX information functions: CONTAINS, CONTAINSROW, CONTAINSSTRING, and CONTAINSSTRINGEXACT.

Navigate through the content below:
0:01 Intro
1:18 DAX Information Functions
1:45 CONTAINS
2:25 CONTAINSROW
3:18 CONTAINSSTRING
3:57 CONTAINSSTRINGEXACT
4:23 Case

___Merchandise [T-Shirts, stickers, mugs, hats, etc.]

___Highly recommended Power BI books (Affiliate links):
***Exper Data Modeling with Power BI by Soheil Bakhshi

___________Relevant PBI Topics
____________

[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.

___________Let's Connect:

Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!

#CONTAINS #DAX #CONSTAINSSTRING #vizxlization #CONTAINSROW
Рекомендации по теме
Комментарии
Автор

Which DAX function do you find more helpful? Navigate through the content below:
0:01 Intro
1:18 DAX Information Functions
1:45 CONTAINS
2:25 CONTAINSROW
3:18 CONTAINSSTRING
3:57 CONTAINSSTRINGEXACT
4:23 Case

NestorAdrianzen
Автор

Gracias por tu respuesta y estaré al pendiente de tus publicaciones.
Saludos Cordiales

rodrigocarrillo
Автор

Hi Nestor.
Although the statement asks for it...
In the third case is possible to use within the measure..
"states" (without wildcards) or "*states*", "?states*", "?states?" (with wildcards)
In this case it's no necessary the use of wildcards.
Super tutorial!!!
Thank you for your explanations.

IvanCortinas_ES
Автор

I want the return to be something else other than true and false. Can we do that without adding a new column?

For example I want to change the value of true to “happy” and false to “sad”

vangelaobli
Автор

Well done Nester...but u didn't explained the reason, why you used "* and ? ",

bharathreddy
Автор

Gracias! excelente explicación ¿porqué ya no lo haces en español?

rodrigocarrillo