Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
For months I have been successfully using the following DAX statement to ashow a Last Refresh Date/Time on my dashboards. This was working with successfully, however since scheduling refrsesh using a personal gateway it seems to be in a less preferred timezone. (For those of you wondering, I have the refresh set to Eastern which is preferred but seems tro be showing UTC on the dashboard.)
= DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())
Looking for suggestions that will allow me to show Eastern Standard Date/Time when refreshed.
Thanks for the help!
Solved! Go to Solution.
Not to be picky, but that's Power Query "M" language, not DAX. You should be able to use:
DateTime.Time(DateTime.LocalNow()) + #duration(0, -5, 0, 0)
Hi @irnm8dn,
There is a known gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC.
There is a workaround to display time in your current time zone. You can use following power query in the Query Editor if your time zone is 5 hours behind Coordinated Universal Time (UTC−05:00).
= DateTime.Time(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 )) & DateTime.Date(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 ))
Regards
Not to be picky, but that's Power Query "M" language, not DAX. You should be able to use:
DateTime.Time(DateTime.LocalNow()) + #duration(0, -5, 0, 0)
Thanks for the clarification.
Below is a representation of the output. I was expectiing 7/13/2017 3:52:50 PM
Thoughts?
Hi @irnm8dn,
There is a known gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC.
There is a workaround to display time in your current time zone. You can use following power query in the Query Editor if your time zone is 5 hours behind Coordinated Universal Time (UTC−05:00).
= DateTime.Time(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 )) & DateTime.Date(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 ))
Regards
Yes, see formula above. Essentially, it is adding/subtracting hours from the date/time value returned from LocalNow to account for the time zone shift. In your case it looks like you would want to use +5?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |