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 

Amar_Kumar's avatar
Amar_Kumar
Super User
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