Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
8 years ago
Solved

Substring in Power BI ?!

Hi All,   I'm coming from Qlikview world, so i'm looking the equivalent of SUBSTRING function.   So, this function will return a string in a specific position, exemple   Value : TD_AA_BB   i ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    You need to use the function

    MID(Txt, StartPosition, NumberOfCharacters)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

You need to use the function

MID(Txt, StartPosition, NumberOfCharacters)

MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

"In Power BI" can mean either DAX (see previous post) or Power Query.

 

A Power Query solution would be to use the option Text After Delimiter under "Extract" in the "Transform" or "Add Column" menu.

 

Screenshot, including the generated formula that will give you the part after the second "_":