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.
I cannot seem to get the last part of this query
Excel
=IF([@[PT reporting change]]="after change",[@[PT 2]],IF([@[PT/NPT]]="PT",IF([@activity]="NONOPS",0,[@DURATION]),IF(OR([@operation]="saftey",[@operation]="commute",[@operation]="lunch"),[@DURATION],0)))
Power Bi-Power Query
if[PT Reporting Change]="AFTER CHANGE" then [PT2]
else if ([activity]="NONOPS" and [#"PT/NPT"]="PT") then 0
else if ([operation]="safety" or [operation]="commute" or [operation]="lunch") then [DURATION] else ""
Solved! Go to Solution.
Here's how your code looks like after playing with it in Powerqueryformatter.com
if [PT Reporting Change] = "AFTER CHANGE" then [PT2]
else if ([activity] = "NONOPS" and [#"PT/NPT"] = "PT") then 0
else if ([operation] = "safety" or [operation] = "commute" or [operation] = "lunch") then [DURATION]
else ""
Your return values can be [PT2], 0, [Duration], or "" . That's not really cool. You want to decide on a column type and then adjust the return values accordingly.
Here's how your code looks like after playing with it in Powerqueryformatter.com
if [PT Reporting Change] = "AFTER CHANGE" then [PT2]
else if ([activity] = "NONOPS" and [#"PT/NPT"] = "PT") then 0
else if ([operation] = "safety" or [operation] = "commute" or [operation] = "lunch") then [DURATION]
else ""
Your return values can be [PT2], 0, [Duration], or "" . That's not really cool. You want to decide on a column type and then adjust the return values accordingly.
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 |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |