Showing the last report refresh time in PST using TIME function

[MyPowerbi2020]

Dear Team,

I am deveoping reports based on IST zone & used the below code while populting the last refresh time.

let

Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})

in

Source

Since this was returning the time in IST , I used this in DAX .

Query1[Date Last Refreshed] - TIME(12,30,0)

Please let me know if you see any issues in this method.

Thanks.

[v-yetao1-msft]

Hi @MyPowerbi2020 

Try a measure like this :

Last Refreshed Date = UTCNOW() + TIME(8,0,0)

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@MyPowerbi2020 you can use a formula like below. You can increase/decrease time from UTC time

Current_Time_PST = UTCNOW()-TIME(00,30,00)

[amitchandak]

@MyPowerbi2020 , Try to use DateTime.AddZone

https://docs.microsoft.com/en-us/powerquery-m/datetime-addzone

example

https://community.powerbi.com/t5/Desktop/Convert-utc-to-local-time-zone-using-Power-Query/m-p/45533

If need use UTC time