Forum Discussion
Solved
Multiple search function in powerbi
Hi, I'm trying to lift the formula from an excel document as below - where B2 is equivalent to a column that contains a mix of characters/numbers in the powerbi table (i.e. "column X" contains ST...
You need to include the optional parameter of a "not found" return value per the SEARCH function specifications:
SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
Greg_Deckler
Community Champion
Community ChampionYou need to include the optional parameter of a "not found" return value per the SEARCH function specifications:
SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])