Forum Discussion
Post ProdigyPower BI Pro showing different dates compared to Desktop
Post ProdigyOkay, did some testing. I create a new column with the different Timezone. I made it so it the time in the record was around 8 hours difference, I did this because my initial thought was that the time change caused a probably.
DateTimeZone.SwitchZone([Option Signed Date], +8)
Here is what it looks like is desktop. This is what it should look like. The record on the bottom is the one I'm having issues with
This is what it looks like on Pro
This puzzled me even more. I had assumed it was a timezone difference but it's a 24 hour differece
Any suggestions?
- michael_knight
Any suggestions?
Hi michael_knight ,
Sorry for late reply... Please check the solution in this thread:
https://community.powerbi.com/t5/Desktop/Convert-UTC-time-to-UK-Time/m-p/578213
Best Regards
Rena
- michael_knight
Thank Anonymous
I'll give that a go. Just so I know, I'm using the USERELATIONSHIP function so I can refer to my date table. Do I apply this step to the date table field or the orginal date field?