Forum Discussion
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 thought Posting_code is 1, cell is populated as "Cyl"
any reason?
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!
2 Replies
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!