Extracting first two characters to create new column

Question

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 · Answer

Hi&nbsp;Justas4478&nbsp;,
&nbsp;
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.

&nbsp;
&nbsp;

justas4478 · Answer

MFelix&nbsp;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 · Answer

Hi&nbsp;Justas4478&nbsp;,
&nbsp;
What do you want to do with that new column?

justas4478 · Answer

MFelix&nbsp;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 · Answer

MFelix&nbsp;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.&nbsp;

Forum Discussion

Extracting first two characters to create new column

7 Replies

Related content

I need to Extract first 3 character ?

Extract part of string before specific character

Extract Cetrain Characters from Text Column

Extract Special Character String /*

Extract Data from sharepoint