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 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!

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      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))
  • 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).