Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |