Hi, I have a KPI in my report that shows the latest refresh. The problem is that it changes when I publish it to the server, maybe is a problem with the timezone. This are the steps that I've done: ...
Anonymous
5 years ago
Solution in Power Query;
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(), -4),#"Converted to Table" = #table(1, {{Source}}),#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "LastRefreshDate"}}),#"Added Custom" = Table.AddColumn(#"Renamed Columns", "AsOf", each "As of "&DateTimeZone.ToText([LastRefreshDate], "MM/dd/yyyy hh:mmtt")),
Show less
Anonymous
Not applicable
5 years ago
Solution in Power Query;
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(), -4),#"Converted to Table" = #table(1, {{Source}}),#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "LastRefreshDate"}}),#"Added Custom" = Table.AddColumn(#"Renamed Columns", "AsOf", each "As of "&DateTimeZone.ToText([LastRefreshDate], "MM/dd/yyyy hh:mmtt")),
