No video :(

Find a Text Term in a Field in Power BI Using DAX Functions

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

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

50% 1

In Power BI, there are multiple ways of searching for a text term inside a text field, you can use Power Query for doing this operation or calculations in DAX. In this video, I'll explain some functions in DAX that you can use to do this calculation. Most of these functions can be used inside a measure for dynamic calculation. In this video, you will learn about a few of DAX functions that deal with search a text term in a text field.
Read more details from my blog post, the link to download the AdventureWorks file, plus links to study more:
radacad.com/fi...

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

6 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

I cannot use TableName[ColumnName] like what you did. I have error. It asks me to use summon,max,... but these are text and I can't use these function at the beginning.

@ManishSharma-sc7cl Год назад

Hello Sir, I have a query Suppose i have two columns like this Name of server. Pre Row Ser1,Ser2,Ser3 Ser2,ser3,Ser4 Ser1,ser2,ser3 Ser3,ser6,ser7. Ser2,Ser3,Ser4 Then how i can find common or repeated value and showing in next column like Ser2,Ser3 This is common in 2nd row Ser3 This is common in 3rd row

@bbeaum1 3 месяца назад

I want to find a term in an entire table or set of tables. Show us how to search it all.

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

Thank you very much dear Mr. Rad.

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

How do you make the search look for values in a non-alphabetical order? I want to search by employee id but it keeps searching in alphabetical order from a separate table

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

Thanks! It was a great help indeed. Can we use similar dax measure?

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

You can use these functions in a measure too.

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

Very useful!

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

How do you make the search look for values in a non-alphabetical order? I want to search by employee id but it keeps searching in alphabetical order from a separate table