Extracting Characters from Power BI Strings using DAX Text Functions | LEFT/ RIGHT/ SEARCH & More!

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

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

50% 1

In this quick video, we'll be using the DAX LEFT, RIGHT, MID, SEARCH & LEN functions to simply and dynamically extract characters from Asset IDs. These functions are transferrable and can be used for all varieties of character strings.
This can also be achieved using Power Query, but sometimes DAX is your only option and therefore, a fundamental skill to have in your Power BI toolkit!
🤝 Visit my Website:
www.matadorsoftware.me/
🤝 Connect with me on LinkedIn:
/ ja376
Please Like, Subscribe, Comment & Share if you enjoy!

Наука

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

24 фев 2022

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@Dhamdard Год назад

These little tricks proved very helpful to me. I work with a set of data with varied sizes of event names but each event has a common string at the end of the event name. These tricks helped me use the left and search together to eliminate the extra string from the event names. Thank you for sharing your knowledge.

@MatadorSoftware Год назад

It’s my pleasure, glad it was helpful!

@vidabailey16 9 месяцев назад

Absolutely excellent, thank you.

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

very helpful, thanks a lot.

@muhammadbilalkhan1918 Год назад

It helped, Thanks alot :)

@MatadorSoftware Год назад

Glad to hear, cheers Muhammad!

@justsayjoe9634 6 месяцев назад

What if you have multiple delimiters in the text string? I have a text string column with 10 underscores that I want to pivot out each of the 11 pieces of text from those ten delimiters. I cannot use power query because it's a calculated table, so I need the right DAX code to peel out each text string from 10 delimiters.

@JJ-rf4rb Год назад

What about the extraction of some sets of characters that are in different positions? I'm using CONTAINSSTRINGEXACT but having problems with the boolean results

@MatadorSoftware Год назад

Ordinarily, I would use an upstream solution like SUBSTRING() in SQL, however if you really needed to use DAX it may be quite complex. You could try to devise a more robust solution in Power Query with M code.