Forum Discussion
Anonymous
7 years agoNot applicable
Include time stamp on dataset view in service
How would I include a time stamp visual that originates from a dataset that is on an autorefresh schedule q2 hours? The goal is to display the time the data set was last refreshed. Thank you
- 7 years ago
Yeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.
Measure 27 = NOW() + .0416666666667 * (1)
Just adjust the + sign and the 1 as needed.
Greg_Deckler
Community Champion
7 years agoYeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.
Measure 27 = NOW() + .0416666666667 * (1)
Just adjust the + sign and the 1 as needed.
Greg_Deckler
Community Champion
7 years agoCreated a Quick Measure for this:
https://community.powerbi.com/t5/Quick-Measures-Gallery/TIMEADD/m-p/585280#M278