Forum Discussion
Date Timezone
Hi good day,
Can anyone help me on my Previous Day calculated column. When i publish my report and refresh at night my Previous day column late for almost half day. my time zone +8hrs KL
Hi AllanBerces ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
You can adjust manually by
PreviousDay =
VAR KLToday = TODAY() + 8/24 -- Manually adjust to KL time
VAR KLYesterday = KLToday - 1
RETURN
IF('DAILY PROGRESS'[Progress Date] = KLYesterday, "Today", 'DAILY PROGRESS'[Progress Date
])
Or in power query,
Go to Transform Data
Add a column with DateTimeZone.FixedUtcNow()
Use DateTimeZone.SwitchZone([YourUtcDate], 😎 to convert to KL time
Extract the date part if needed
Please mrk this anwer as complete
4 Replies
Note that the Power BI service runs on UTC. You should base all your calculations on UTC as well. So instead of using TODAY() use UTCTODAY() etc.
Hi lbendlin thank you for the reply will try on this.
Hi AllanBerces ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
You can adjust manually by
PreviousDay =
VAR KLToday = TODAY() + 8/24 -- Manually adjust to KL time
VAR KLYesterday = KLToday - 1
RETURN
IF('DAILY PROGRESS'[Progress Date] = KLYesterday, "Today", 'DAILY PROGRESS'[Progress Date
])
Or in power query,
Go to Transform Data
Add a column with DateTimeZone.FixedUtcNow()
Use DateTimeZone.SwitchZone([YourUtcDate], 😎 to convert to KL time
Extract the date part if needed
Please mrk this anwer as complete
