Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

issue with new column

Hi I have this query   Dept = Switch(SELECTEDVALUE(Delivery_transaction_details[posting_code]), 1,"Bulk", 2,"Bulk", 10,"Bulk", 99,"Bulk", "Cyl")   new column Dept is created, but even thoug...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous change to this

     

    Dept = Switch(Delivery_transaction_details[posting_code],
1,"Bulk",
2,"Bulk",
10,"Bulk",
99,"Bulk",
"Cyl")

     

    removed SELECTEDVALUE function

     

    I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation! 

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous change to this

 

Dept = Switch(Delivery_transaction_details[posting_code],
1,"Bulk",
2,"Bulk",
10,"Bulk",
99,"Bulk",
"Cyl")

 

removed SELECTEDVALUE function

 

I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!