Forum Discussion

PowerBiPro2000's avatar
PowerBiPro2000
Frequent Visitor
3 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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's avatar
Greg_Deckler
Community Champion
3 years ago

PowerBiPro2000 Oh, sorry, PQ, then this:

= Table.AddColumn(#"Changed Type", "Custom", each #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [EPOCH COLUMN]/1000))

You don't use table references in PQ

PowerBiPro2000's avatar
PowerBiPro2000
Frequent Visitor
3 years ago

Greg_Deckler   What does the "Changed Type" represent?  I can't get past "Expression.Error: The name 'Changed Type' wasn't recognized. Make sure it's spelled correctly"   I'm surprised how difficult it is to convert Epoch dates (at least it has been for me).