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 dots .
The output should be like this
Messaging
Phone
Meeting
Could any one please help hoe to do this
Text.Split is a power query function, not DAX. You would add it in the query editor.
Pat
3 Replies
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