Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I need help with multiple if conditions writing a conditional statement
for the below logic
≤9.0%= 10 pts
>9% and 2 ppt <2022rate = 10 pts
>9% and 1-1.99 ppt <2022 rate= 5pts
I tried the below statement didn't give the right result
color_annual =
if('PCR_Summary_D/M/Q/Y'[RATE-%]<=9 ,
"10pts",
if(and('PCR_Summary_D/M/Q/Y'[RATE-%]>9,'PCR_Summary_D/M/Q/Y'[RATE-%YOY]>=1.99),"5pts","0pts"))
@vemana256 Maybe:
color_annual =
SWITCH(TRUE(),
'PCR_Summary_D/M/Q/Y'[RATE-%] <= .9 , "10pts",
'PCR_Summary_D/M/Q/Y'[RATE-%] > .9 && 'PCR_Summary_D/M/Q/Y'[RATE-%YOY] >= 1.99), "10pts",
'PCR_Summary_D/M/Q/Y'[RATE-%] > .9 && 'PCR_Summary_D/M/Q/Y'[RATE-%YOY] <= 1.99), "5pts",
"0pts"
)