TODAY() not returning today's date

DAX DAX Calculations
1

Hi,
I’ve got a bit of weird issue. The DAX function TODAY() is not returning a correct date.
For eg: at the time of this posting TODAY() is returning 12/08/2021 when it is 13/08/2021

The main problem is the same source file on desktop returns 13/08/2021 whereas the one currently hosted on the power bi online service returns 12/08/2021.

I have already tried republishing the same file again, it will work till end of today but will have same issue the next day.
I have looked everywhere but unable to find the correct answer to this. And my current time zone is UTC+10

image

Any help would be highly appreciated.

Thanks

2

HI @40ART

The problem is due to timezone gap setting of your system and power bi service. To fix this you can use below formula UTC instead of simple Today

test = UTCNOW() + 0.5

image

The number 0.5 is used to subtract the timezone difference for 10hrs it is 0.5 so you can adjust it to get correct date as per your need and testing.

Also below is the link to post where you will find steps in detail how you can handle in power query.

Thanks
Mukesh

3

Hi @MK3010 ,

How did you came up with addition of converting + 10 to 0.5

image

A bit confused.

Thanks

4

Hi @40ART

That’s not the exact number I just wrote how to calculate and you can test in your environment. By the way below formula will give you more clear picture, I adjusted 5 hrs to reach 00:00 time you can try in your environment with this concept.

UTCAdjusted = UTCNOW() - TIME(5,0,0)

image

Thanks
Mukesh

1 Like
5

Thanks @MK3010 .

Makes sense now.
Appreciate your help.

1 Like