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))
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
3 years ago

You don't need to include the table name. In fact, by using MyTable[EPOCH COLUMN] it is converting that to a list, then you are dividing a list by 1000.

 

Get rid of the MyTable designation. Is the data in this table? If not, you need to merge it in. You cannot reference data in other tables the same way you can DAX. 

As for the formula, see Working with Unix Epoch Time In Power BI — ehansalytics - I am not sure you need the 1000 divisor