Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
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
User | Count |
---|---|
94 | |
89 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |