Power BI Tips | Data Update Time in Reports | Avalytics
With this Power BI Tip we want to show how you can see your data update time in reports.
Šiame Power BI patarime dalinamės patarimu, kaip galite matyti savo duomenų atnaujinimo laiką ataskaitose.
Formula:
let
Source = DateTimeZone.UtcNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Data UTC"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Data UTC", type datetimezone}}),
#"Inserted Local Time" = Table.AddColumn(#"Changed Type", "Data UTC+3", each DateTimeZone.SwitchZone([Data UTC], 3)),
#"Changed Type1" = Table.TransformColumnTypes(#"Inserted Local Time",{{"Data UTC+3", type datetimezone}})
in
#"Changed Type1"
Learn how to put dynamic text in your report: • Power BI Tips | Dynamic Text Addition | Av...