Forum Discussion
Justas4478
Post Prodigy
Post ProdigyExtracting 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...
Justas4478Post Prodigy
Post ProdigyMFelix 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.
Justas4478Post Prodigy
Post ProdigyMFelix 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
Super User
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.
