Issue with a measure using today function

[kkalyanrr]

Hello ,

I'm using a measure in my desktop where measure1 = today()... I'm displaying target values..

But now the issue my client is Australia based but the target numbers are refreshing late in the day..he is able to see the changes after 10'o clock his time..I think though I'm using today() function its bydefault taking UTCtoday() in service..
Any ideas on fixing this issue.

[mwegener]

Hi @kkalyanrr ,

was your problem solved?

[amitchandak]

@kkalyanrr , refer if this can help

https://www.youtube.com/watch?v=M1zquwmpnZE

https://www.youtube.com/watch?v=2kmFfbOeFJg

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

[Pragati11]

HI @kkalyanrr ,

Try checking following thread if that helps:

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

Thanks,

Pragati

[harshnathani · Accepted solution]

Hi @kkalyanrr ,

You can have a look at this blog too.

https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/

Regards,

Harsh Nathani