Forum Discussion

mgusty33's avatar
mgusty33
Frequent Visitor
8 years ago
Solved

Multiple rows same values in one column but not another

In the example shown below, ticket 1 was sent to multiple people for approval.  Person A Rejected it before B did anything, so the ticket was rejected, but still marked on “Open” for B. So then when ...
Need Help
Show and Tell
  • mgusty33's avatar
    mgusty33
    8 years ago

    I managed to figure out a solution. I duplicated the query and on the new query I filtered for "Rejected" and removed duplicate ticket numbers (In case 2 of the 4 rejected). I filtered the original query on just department "2b". I then merged the new one back with original one as a new column called "New Status". It made it so some of the "New Status" columns were blank, so I then added another column with the equation 

     

    if [#"New_Status"] = null then [Status] else [#"New_Status"])

     

    This gave me the "Rejected" status if any person rejected it for that ticket.