Forum Discussion

RobinH's avatar
RobinH
Icon for Helper I rankHelper I
6 years ago
Solved

DateTime.LocalNow() in Conditional column

Hey everyone   I try to create a column with the information if a ticket was closed out of the SLA or not. I have a table with all tickets (closed and open ones). with the closed Tickets it's not ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    I believe you want:

     

    #"Added Conditional Column5" = Table.AddColumn(#"Rounded Up", "SLA Meassure Date", each if [State] = "Closed" then [Update time] else if [State] = "Completed" then [Update time] else if [State] = "Aborted" then [Update time] else DateTime.LocalNow()),

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

I believe you want:

 

#"Added Conditional Column5" = Table.AddColumn(#"Rounded Up", "SLA Meassure Date", each if [State] = "Closed" then [Update time] else if [State] = "Completed" then [Update time] else if [State] = "Aborted" then [Update time] else DateTime.LocalNow()),