Forum Discussion
Solved
13 digit EPOCH getting error when adding new column
I am trying to convert this Epoch date column into a useable date with seconds: EPOCH COLUMN 1669749375000 I'm adding a column and using this formula Useable Date = #datetime(1970, 1...
PowerBiPro2000 That's a reference to the step before the current step. You can just add a column and paste in this part of the formula:
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [EPOCH COLUMN]/1000))
Greg_Deckler As expected, it was my error! However, now I am getting this error: Expression.Error: The name 'Changed Type' wasn't recognized. Make sure it's spelled correctly.
What am I doing wrong? Thank you for your help!
PowerBiPro2000 That's a reference to the step before the current step. You can just add a column and paste in this part of the formula:
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [EPOCH COLUMN]/1000))