Forum Discussion

tonijj's avatar
tonijj
Helper IV
5 years ago
Solved

Switch function with LEFT different conditions

Hi,   I have a datatable with Order numbers. The number series translate to different types of Orders. I would like to create a DAX formula that does the translation, like SWITCH.    The rules th...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    tonijj,

     

    Try this calculated column:

     

    Category = 
SWITCH (
    TRUE (),
    LEFT ( OrderNumber[OrderNumber], 4 ) = "G101", "CAPEX",
    LEFT ( OrderNumber[OrderNumber], 4 ) = "G104", "CAPEX",
    LEFT ( OrderNumber[OrderNumber], 4 ) = "G102", "OPEX",
    LEFT ( OrderNumber[OrderNumber], 1 ) = "F", "CAPEX",
    LEFT ( OrderNumber[OrderNumber], 1 ) = "O", "OPEX"
)

     

     

DataInsights's avatar
DataInsights
Super User
5 years ago

tonijj,

 

Try this calculated column:

 

Category = 
SWITCH (
    TRUE (),
    LEFT ( OrderNumber[OrderNumber], 4 ) = "G101", "CAPEX",
    LEFT ( OrderNumber[OrderNumber], 4 ) = "G104", "CAPEX",
    LEFT ( OrderNumber[OrderNumber], 4 ) = "G102", "OPEX",
    LEFT ( OrderNumber[OrderNumber], 1 ) = "F", "CAPEX",
    LEFT ( OrderNumber[OrderNumber], 1 ) = "O", "OPEX"
)