How Can I write this Statement in Power BI

[drrai66]

Hi Guys,

This  Tableau Statement Excludes Strings  containing "Mainframe" and "Mobile" from the  Field called Platform in my Data.

How Can I write This Equivalent Statement in Power BI

Thanks

Deepak

[Phil_Seamark · Accepted solution]

HI @drrai66

I think I follow what you are after and this might be close

        NOT (
            SEARCH("Mainframe",[Platform TYpe],1,0) > 0 && 
            SEARCH("Mobile",[Platform TYpe],1,0) > 0
            )

This will match where you have both the terms "Mobile" and "Mainframe" in the same text field.

[Phil_Seamark · Accepted solution]

HI @drrai66

I think I follow what you are after and this might be close

        NOT (
            SEARCH("Mainframe",[Platform TYpe],1,0) > 0 && 
            SEARCH("Mobile",[Platform TYpe],1,0) > 0
            )

This will match where you have both the terms "Mobile" and "Mainframe" in the same text field.

[drrai66]

No Sir , Unfortunately , it did not work 

 I have this statement in Tableau and want to convert to Power BI . I have tried but results are not matching. So need Help. 

In Tableau

IF [A]<>"Yes"

AND [B]<>"Locally Deployed"

AND  [C]<>"Yes"

AND [D]<>"Yes" 

AND NOT CONTAINS([Platform Type],"Mainframe")

AND  NOT CONTAINS([Platform Type],"Mobile")

AND [Hosted By]="XYZ"

AND [System Type]="Application"

AND [F]<>0

AND [G]<>0

Then

"Eligible"

ELSE

"N/A"

END

My FORMULA  in Power BI

IF(Table[A]<>"Yes"  &&

Table[B]<>"Locally Deployed"

&& Table[C]<>"Yes"

&& Table[D]<>"Yes"

&& Not CONTAINS (Table,Table[Platform Type],"Mainframe",Table[Platform Type],"Mobile") 

&& Table[Hosted By]="XYZ"

&& Table[System Type]="Application"

&& Table[F]<>0

&& Table[G]<>0,"Eligible","N/A")

The thing is I created a Table using above logic and I am getting CORRECT values using Filters, But  I need above formula to work to create my views.

Please Help.

Thanks a lot for your time

Regards

Deepak

[drrai66 · Accepted solution]

I was able to Solve it