Forum Discussion
Power Bi gets wrong date from SHP list
Hi, I have a problem that powerBi gets date from SHP list in a wrong timezone. In shp - i have 21.04.2020 But in powerBi I can see 20.04.2020 23:00 Any quick fix?
So seems like PowerBi gets UTC time. I created custom column:
[Date] + #duration(0,2,0,0) - by that I can get correct time. The problem is it is only true for half of the year...
By the end of the march we moved our time by 1 hour. Should I use "IF" that adds 1 or 2 hour in diferent part of the year? Or is there a better option?
This one seems to be incorrect:
if [Date] > "29.03.2020 23:00:00" then [Date] + #duration(0,2,0,0) else [Date] + #duration(0,1,0,0)