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()),

     

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

Hi RobinH 

 

Go to Added Conditional Column Step and In the Formula Bar, remove quotes from around DateTime.LocalNow() to convert it from text to a function.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn