Forum Discussion
convert multiple case statements in sql to dax
Anonymous , You can use Switch with True
example
Switch(True() ,
[SCODE]) = 47123 , [Total Actual]+1350 ,
isblank([Total Budget_Food]) , -1*[Total Budget],
divide([Total Budget_Food] END), [Total ComparedOcc_FB]*[Max Negation])
)
same way you can add another switch true
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
Anonymous , You can use Switch with True
example
Switch(True() ,
[SCODE]) = 47123 , [Total Actual]+1350 ,
isblank([Total Budget_Food]) , -1*[Total Budget],
divide([Total Budget_Food] END), [Total ComparedOcc_FB]*[Max Negation])
)
same way you can add another switch true
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56