Forum Discussion
How to extract words between dots from a string
Hello All, I am new to power BI I have category column having values like below. zSoftware.Messaging.Error zHardware.Phone.Other zHardware.Meeting.Other I need to extract word between dot...
Text.Split is a power query function, not DAX. You would add it in the query editor.
Pat
You can use this expression. It makes a list of words split at the "." and then takes the 2nd one (counting in PQ starts at 0).
Text.Split([Column1], "."){1}
Pat