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

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi RobinH ,

It is caused by double quotes("DateTime.LocalNow()"). If you use "", it will return the entire contents of anything inside them as text. So, you just need to remove them and then the function will work fine.