Solved: Problem Converting UNIX time power bi desktop

migue7899 · ‎11-24-2017

hi

in this topic explain how to convert the unix time type into power bi desktop:

my problem is that my time zone is gmt less -7 as I can do this conversion thanks.

MarcelBeug · ‎11-24-2017

Adjust the formula with -7 as hours in the #duration part:

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

Specializing in Power Query Formula Language (M)

MarcelBeug · ‎11-24-2017

Adjust the formula with -7 as hours in the #duration part:

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

Specializing in Power Query Formula Language (M)

migue7899 · ‎11-25-2017

excellent and I'm resolved thank you marcel

Problem Converting UNIX time power bi desktop