Forum Discussion
Solved
Problem Converting UNIX time power bi desktop
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.
Adjust the formula with -7 as hours in the #duration part:
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, -7, 0, [UnixTime]/1000)
2 Replies
Adjust the formula with -7 as hours in the #duration part:
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, -7, 0, [UnixTime]/1000)
