Extracting first two characters to create new column

[Justas4478]

Hi, I am trying to do simple measure but it doesn't wan't to work for some reason.

I have this data: And I need to extract first two characters to create new column called gates.
For example from G1P0 I want to extract G1, same for G1P2 as well G2P0 etc.

I tried using this measure that should have worked but it isnt working for some reason.

Gate = LEFT('PickReport'[Floor],2)

Thanks

[MFelix]

Hi @Justas4478 ,

Measure only work with aggregations so you cannot do a LEFT. You need to select the table were you have this informaiton and add a new column, the syntax is correct.

[Justas4478]

@MFelix Hi, I cant create new column since my data connection is through power bi semantic model. Is there any other way that it can be done?

[MFelix]

Hi @Justas4478 ,

What do you want to do with that new column?

[Justas4478]

@MFelix The current column has gates(warehouses) and floors in the same column. I need to have second column that has only gates without any floors.

[Justas4478]

@MFelix I tried to create using SWITCH function but it only works when I have no more than one value selected in filter.
I tried other than 'SELECTEDVALUE' but then measure just return error.

[MFelix]

You want to use tihs new column in your slicer is that it?

[Justas4478]

@MFelix Yes I would like to use it as a slicer if possible.