Forum Discussion

chel4782's avatar
chel4782
Frequent Visitor
6 years ago
Solved

Need help with conditional column

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 ""

Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    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.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    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.