issue with new column

[salman_ali]

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?

[salman_ali]

Thanks so much, that worked!!

[parry2k · Accepted solution]

@salman_ali 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!