Forum Discussion

SelvakumaranM's avatar
SelvakumaranM
Frequent Visitor
4 years ago

Conditional values in calculated column

Hi Experts,   I have create a calcualted column like below city group = SWITCH( TRUE(), SELECTEDVALUE(Orders[City - Copy]) in {"Columbus","San Francisco"},"Columbus/san", SELECTEDVALUE(Orders[C...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, SelvakumaranM 

 

First, calculated columns usually don't need to use SELECTEDVALUE(), you can directly use the column name to represent the value of the current row, just like parry2k  wrote. Is your problem solved?

 

 

i need to take values from sales column for Dublin, Washington, Columbus and New York City only . when i create an IF condition and put in table, it shows zero values for all . 

 

But I don't know what you mean by demand in your last sentence. Your calculated column displayed the combined result, but you mentioned a series of single cities, can you explain it?

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,

Community Support Team _Janey