Date Timezone

[AllanBerces]

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

Previousday = if('DAILY PROGRESS'[Progress Date]=TODAY()-1,"Today",""& 'DAILY PROGRESS'[Progress Date]) 

Thank you

[v-nmadadi-msft · Accepted solution]

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.

[Amar_Kumar · Accepted solution]

@AllanBerces 

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 

[v-nmadadi-msft · Accepted solution]

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.

[lbendlin]

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.

[AllanBerces]

Hi @lbendlin thank you for the reply will try on this.