Power BI CONTAINS, CONTAINSSTRING & CONTAINSSTRINGEXACT function

Подписаться 2,8 тыс.

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

50% 1

This is a short video with an example on how to use contains, containsstring and containsstringexact function in power bi.
The examples are kept simple and short.
Other Videos which you might be interested:
1. Summarize Columns : • Power BI SUMMARIZECOLU...
2. Change the color of Selected Button : • Power BI Change Button...
3. Hide and Unhide Visuals to optimize space : • Power BI Hide and Unhi...
4. Earlier function : • Power BI EARLIER function
5. Selected Measure or Calculated group : • Power BI SELECTEDMEASU...
6. DatesMTD, DatesQTD, DatesSYTD : • Power BI DATESMTD, DAT...
7. Targets & Trend : • Power BI Measures show...
8. Blank, Isblank, Isnumber, Istext : • Power BI BLANK, ISBLAN...
9. Select Columns : • Power BI SELECTCOLUMNS...
10. Divide by Zero Error Handling : • Power BI Divide by Zer...
11. Mean , Median, Mode : • Power BI Mean(Average)...
12. Many to many relationship : • Power BI Many to Many ...
13. Count working days, exclude holidays : • Power BI Network days ...
14. Weekly Rolling average : • Power BI Weekly Rollin...
15. Enable tabular editor : • Power BI Enable EXTERN...
16. Add Columns : • Power BI ADDCOLUMNS fu...
17. Contains, Containsstring : • Power BI CONTAINS, CON...
18. Variance & Standard Deviation : • Power BI VAR.S and STD...
19. Row Number : • Power BI Row_Number Ov...
20. Summarize : • Power BI SUMMARIZE fun...

Наука

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

8 авг 2020

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Super helpful! Thank you

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

Thank you ..

@AarasiKesari Год назад

How to create a measure which shows all the types of furniture. Such that if I click on sofa.. all the cells containing sofa would appear and if I click on Tables all the cells having tables will be visible? I tried using if and contains string.. but problem is when I click on sofa.. everything comes and when I click on tables.. only the left cells shows up..

@LifeofBusinessAnalystLoBA Год назад

Have you checked this video ?? Power BI In Operator with IF Statement | Text search within multiple rows | Dynamic IF using table ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PZImlnEr2QI.html

@vangelaobli 11 месяцев назад

How do you change the true and false to a certain word?

@LifeofBusinessAnalystLoBA 11 месяцев назад

Use logical operator.. if result is true, then your word else different word.

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

Thanks so much for your help.

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

You are welcome ..

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

Hi, instead of yes or no return, how to get a count of value. For eg. If a cell has Sofas mentioned 4 times, I need a return value 4 instead of Yes or No. Thanks

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

hi , Could you try something like this : Test = var v_text = len("Sofas") return (LEN(SELECTEDVALUE('Fact'[Furniture]))- len(SUBSTITUTE(SELECTEDVALUE('Fact'[Furniture]),"Sofas","")))/v_text