Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi folks,
I need some help.
Need to extract a string from another string.
<SOME TEXT HERE> : It can be a great text or a simple text.
It can be in DAX or in Function M
TEXT | Result |
<SOME TEXT HERE> Accepted by: Williams Portela <SOME TEXT HERE> | Williams Portela |
<SOME TEXT HERE> Accepted by: Rose Davis Harris <SOME TEXT HERE> | Rose Davis |
<SOME TEXT HERE> Accepted by: James Anderson Taylor <SOME TEXT HERE> | James Anderson |
Can anyone help me?
TKssss!!!!
Solved! Go to Solution.
You can Merge these all together with VAR or nested logic, but I've broken them out to show the thought process flow...
Proud to give back to the community!
Thank You!
TEXT | Result |
<SOME TEXT HERE> Accepted by: Williams Portela <SOME TEXT HERE> | Williams Portela |
<SOME TEXT HERE> Accepted by: Rose Davis Harris <SOME TEXT HERE> | Rose Davis |
<SOME TEXT HERE> Accepted by: James Anderson Taylor <SOME TEXT HERE> | James Anderson |
Are you OK with logic that says 'the next two words after a ":"?
Proud to give back to the community!
Thank You!
exacly
You can Merge these all together with VAR or nested logic, but I've broken them out to show the thought process flow...
Proud to give back to the community!
Thank You!