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

Deepak

 

 

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.

3 Replies

  • 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