Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

How Can I write this Statement in Power BI

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 Dee...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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's avatar
    drrai66
    8 years ago

    I was able to Solve it

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago

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's avatar
    drrai66
    Icon for Resolver I rankResolver I
    8 years ago

    I was able to Solve it