Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |