Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

FIND EXACT WORD IN A COLUMN

Hi,

 

I want to know if the Column1 has an "INTERN" word on it. As you can see on the 2nd column (INTERN WORD) all output are returning True because there's an intern word within a word. The 3rd column shows the correct output which returns true if there's a separate word "Intern".

 

nicomathers_0-1692726309485.png

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Anonymous 

plrase try

INTERN WORD =
VAR String =
SUBSTITUTE ( SUBSTITUTE ( 'Table'[Column1], "(", "" ), ")", "" )
VAR Items =
SUBSTITUTE ( String, " ", "|" )
VAR Length =
COALESCE ( PATHLENGTH ( Items ), 1 )
VAR T1 =
GENERATESERIES ( 1, Length, 1 )
VAR T2 =
SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )
RETURN
NOT ISEMPTY ( FILTER ( T2, [@Item] = "Intern" ) )

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Anonymous 

plrase try

INTERN WORD =
VAR String =
SUBSTITUTE ( SUBSTITUTE ( 'Table'[Column1], "(", "" ), ")", "" )
VAR Items =
SUBSTITUTE ( String, " ", "|" )
VAR Length =
COALESCE ( PATHLENGTH ( Items ), 1 )
VAR T1 =
GENERATESERIES ( 1, Length, 1 )
VAR T2 =
SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )
RETURN
NOT ISEMPTY ( FILTER ( T2, [@Item] = "Intern" ) )

Anonymous
Not applicable

This works. Thanks, Mate!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.