Forum Discussion

PowerBIExplorer's avatar
PowerBIExplorer
Frequent Visitor
8 years ago

Excel Countif in Power BI

Hi 

 

 

How can I convert this excel formula in column I4 and create a calculated column in Power BI?

=IF(COUNTIF(V4:W4,"Yes")=2, 1, IF(COUNTIF(V4:W4,"Yes")=1, 0.5, 0))

 

 

 

Need Help

1 Reply

  • danb's avatar
    danb
    Resolver I
    8 years ago

    PowerBIExplorer

     

    Try:

    Solution = if(AND(Table1[Column V]="Yes",Table1[Column W]="Yes"),1,if(OR(Table1[Column V]="Yes",Table1[Column W]="Yes"),.5,0))