Forum Discussion

susheeltyagi's avatar
susheeltyagi
Icon for Helper I rankHelper I
5 years ago
Solved

Need help for converting Unix EPOC time to DateTime convertion in Power BI

Hi   I need the expert help. I am trying to convert the EPOC Unix time to Date Time in Power BI (Advance Editor). I am using the below formula for conversion but I don't know where I am wrong the...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    susheeltyagi , Try in power query like

    #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [UnixTime]/1000)

     

     

    New column in DAX

    New column 
VAR conversion = 'Table1'[unixtime]/(60*60*24)
RETURN 
Date(19701,1,1)+conversion
  • susheeltyagi's avatar
    susheeltyagi
    5 years ago

    HI,

     

    I have got mine Mistake . My Unix Time dataType was Text. I have converted to WholeNumber and the below query perfectly converted to the DateTime Correctly. 

     

    New Column =

    #datetime(1970,1,1,0,0,0) + #duration(0,0,0,[ScrubberTime])

     

    Thanks for your support.

     

     

susheeltyagi's avatar
susheeltyagi
Icon for Helper I rankHelper I
5 years ago

HI,

 

I have got mine Mistake . My Unix Time dataType was Text. I have converted to WholeNumber and the below query perfectly converted to the DateTime Correctly. 

 

New Column =

#datetime(1970,1,1,0,0,0) + #duration(0,0,0,[ScrubberTime])

 

Thanks for your support.