Forum Discussion
Help with Filtering & Slicer
Hi amitchandak & Greg_Deckler, thanks for your replies.
The issue was not explained very clearly, my bad. To rephrase it, I would simply need a new column, indicating the floor level. It could be done manually with conditional column based on Level ID column, where
Level ID column -> equals -> BM00 = Output Basement
Level ID column -> equals -> GF101 = Output Ground Floor
Level ID column -> equals -> F2.0 = Output 2nd Floor
Level ID column -> equals -> F3.0 = Output 3rd Floor
But my real dataset contains over 200 rows, and more appears almost everyday. The amount of rooms belonging to each floor level is irregular. So is there a simple code or DAX expression where I could create a new column based on the Level ID?
This is what Im looking for. Hopefully now I explained it a bit better 😄 Feel free to ask more explination if needed.
-Jere
create a calculated column:
FloorDetails=SWITCH([Level ID],
"BM00" ,"Basement",
"GF101" ,"Ground Floor",
"F2.0" ,"2nd Floor",
"F3.0" ,"3rd Floor","unidentified")