Forum Discussion
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 ...
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()),
Wow love this Community.
Thank you all for this fast responses.
Best Regards
Robin