Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
drrai66
Resolver I
Resolver I

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

 

 

Platform.PNG

2 ACCEPTED SOLUTIONS
Phil_Seamark
Employee
Employee

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

I was able to Solve it

View solution in original post

3 REPLIES 3
Phil_Seamark
Employee
Employee

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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

I was able to Solve it

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.