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
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.

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

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

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

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