Forum Discussion

Macc-PA's avatar
Macc-PA
Helper I
5 years ago
Solved

Change datetime column value conditionally without creating new columns.

Hi,   I am trying to change the value of a datetime column based on certain conditions. Is it possible to do so without having to create new columns.   I have tried the following using the patter...
Need Help
  • Jakinta's avatar
    Jakinta
    5 years ago
    = Table.TransformColumns(LastEditDate,{{"LasteditDate", each if Time.Hour(_) = 21 then _ + #duration(0,1,31,0) else _, type datetime}})
Jakinta's avatar
Jakinta
Solution Sage
5 years ago
= Table.TransformColumns(LastEditDate,{{"LasteditDate", each if Time.Hour(_) = 21 then _ + #duration(0,1,31,0) else _, type datetime}})
  • Macc-PA's avatar
    Macc-PA
    Helper I
    4 years ago

    Thank you - worked great.