Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have below if logic inTableau. Please can you help me to convert same in Power BI.
high priority=if [Reached Active?]="Yes" and [Reached Priority?]="Yes" and [Reached High Priority?]="Yes" and [Completed/Portfolio?]="No" then
if [Status (adjust)]="On hold" or [Status (adjust)]="Onhold-Tracked" then "Yes" else
if [Status (adjust)]="Monitor" or [Status (adjust)]="Active" or [Status (adjust)]="Priority" then "Yes"
else "No" END
END
else "No" END
Solved! Go to Solution.
Hi @paw1 ,
Please have a try.
Create a column.
high priority =
IF (
table[Reached Active?] = "Yes"
&& table[Reached Priority?] = "Yes"
&& table[Reached High Priority?] = "Yes"
&& table[Completed/Portfolio?] = "No",
"No",
IF (
table[Status (adjust)] = "On hold"
|| table[Status (adjust)] = "Onhold-Tracked",
"Yes",
IF (
table[Status (adjust)] = "Monitor"
|| table[Status (adjust)] = "Active"
|| table[Status (adjust)] = "Priority",
"Yes",
"No"
)
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @paw1 ,
Please have a try.
Create a column.
high priority =
IF (
table[Reached Active?] = "Yes"
&& table[Reached Priority?] = "Yes"
&& table[Reached High Priority?] = "Yes"
&& table[Completed/Portfolio?] = "No",
"No",
IF (
table[Status (adjust)] = "On hold"
|| table[Status (adjust)] = "Onhold-Tracked",
"Yes",
IF (
table[Status (adjust)] = "Monitor"
|| table[Status (adjust)] = "Active"
|| table[Status (adjust)] = "Priority",
"Yes",
"No"
)
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |