Calculated columns with multiple IF's conditions

[ANKITBISANI]

Hello All ,

I have a scenario as below . I need to have a calculated columns with below condition as shown in the below table(Calculated columns).

I have used switch as below but not getting the answer:

Column = SWITCH(CF_Savings_Ownership[Attribute],"One year ago", CF_Savings_Ownership[page2_WT] * 1 ,
"Two years ago", CF_Savings_Ownership[page2_WT] * 2,
"More than 5 years ago", CF_Savings_Ownership[page2_WT] * 5,"null")

Attribute	page2_wt	calculated columns
More than 5 years ago	0.023	(if attribute = 'one year ago ' then page2_wt * 1 ,if attribute = 'Two years ago ' then page2_wt* 2 ,If attribute = 'More than 5 years ago' then page2_wt * 5)
More than 5 years ago	1.023
More than 5 years ago	2.023
One year ago	3.023
One year ago	4.023
More than 5 years ago	5.023
More than 5 years ago	6.023
More than 5 years ago	7.023
Two years ago	8.023

Regards ,

Ankit

[ANKITBISANI]

Hello All

if [Attribute]= "One year ago" then 1 else if [Attribute]="Two years ago" then [page2_WT]*2 else if

[Attribute]="2-5 years ago" then [page2_WT]*3.5 else if [Attribute]="More than 5 years ago" then [page2_WT]*5 else 2000

Regards

[v-shex-msft · Accepted solution]

Hi @ANKITBISANI,

You can also try to use switch function.

Calculate column:

Reuslt = 
var multi=SWITCH([Attribute],"one year ago",1,"Two years ago",2,"2-5 years ago",3.5,"More than 5 years ago",5,0)
return
[page2_wt]*multi +if(multi=0,2000)

Regards,

Xiaoxin sheng