Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all - I have figured out a way to add the automatic Last Date-Time Refresh to local timezone with two simple and straight-forward DAX functions that I'd like to share with you.
If you have tried to set-up the local time on desktop version but the dashboard always reflects the GTW time whenever auto-refresh occured, it's because the Last Date-Time refers to the last refresh of Power BI server based on GTW. You can follow step by step below and it will work flawlessly no matter which local timezone you are.
DAX= Table.AddColumn(#"Renamed Columns", "Last Refresh Date Time", each DateTimeZone.FixedUtcNow(), type datetimezone)
DAX= Table.AddColumn(#"Added Custom", "PST", each DateTimeZone.SwitchZone([Last Refresh Date Time], -7), type datetimezone)
This works great! Thank you for this.
@Anonymous How does this work with Daylight Saving Time? Meaning, when DST ended/began in November/March, did the timezone automatically update to reflect DST, or did you have to manually swtich between -7 and -8 in the formula?
If the latter, is there a way to filter the formula based on when DST actually occurs?
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |