Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

Extracting first two characters to create new column

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 G...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

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's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

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's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Justas4478 ,

     

    What do you want to do with that new column?

    • Justas4478's avatar
      Justas4478
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      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's avatar
        Justas4478
        Icon for Post Prodigy rankPost Prodigy
        2 years ago

        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.