Forum Discussion
Helper IVShowing the last report refresh time in PST using TIME function
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 .
3 Replies
- amitchandak
Super User
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
- negi007
Community Champion
MyPowerbi2020 you can use a formula like below. You can increase/decrease time from UTC time
Current_Time_PST = UTCNOW()-TIME(00,30,00) 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.
