Forum Discussion
m_roussakis
Helper III
Helper IIILooking to subtract time from a date.Time column in Power Query
I have this formula : new column = if [EVT_CD] = "TF" then [EVT_TMSTMP] - #duration(0, 1, 0) else [EVT_TMSTMP] but it gives me an error in new column. My [EVT_TMSTMP] column is in Date/Time...
Your mention of requiring 4 parameters jogged my memory and i was able to fix this. Thanks!
= if [EVT_CD] = "TF" then [EVT_TMSTMP] - #duration(0, 0, 1, 0) else [EVT_TMSTMP]
m_roussakisHelper III
Helper IIIYour mention of requiring 4 parameters jogged my memory and i was able to fix this. Thanks!
= if [EVT_CD] = "TF" then [EVT_TMSTMP] - #duration(0, 0, 1, 0) else [EVT_TMSTMP]