Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

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   Previo...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    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's avatar
    Amar_Kumar
    1 year ago

    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 

lbendlin's avatar
lbendlin
Super User
1 year ago

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's avatar
    AllanBerces
    Post Prodigy
    1 year ago

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