How to extract words between dots from a string

[Anonymous]

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

[ppm1]

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

[Anonymous]

Hi @ppm1 ,

I dont see any function with text.split when I create a column.

Could you please let me know where we need to use this exactly

[ppm1 · Accepted solution]

Text.Split is a power query function, not DAX. You would add it in the query editor.

Pat