Forum Discussion
anjanikumar
Helper III
Helper IIIHow to convert to DAX !!
Hi Could you please convert below two Cognos Case statements to convert to calculated column of DAX in Power BI. Please help me asap. Thanks in Advance. 1 case when ( [Year] ='CY' ...
anjanikumar , Use Switch
Switch ( True() ,
[Year] ="CY" && [SKU Status]="Active" , [SKU Count] ,
0 )2
Switch(True() ,
[Year]=" CY" , [Invoice Cases] ,
0 )
Switch- the Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
amitchandak
Super User
Super Useranjanikumar , Use Switch
Switch ( True() ,
[Year] ="CY" && [SKU Status]="Active" , [SKU Count] ,
0 )
2
Switch(True() ,
[Year]=" CY" , [Invoice Cases] ,
0 )
Switch- the Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56