Forum Discussion

learner03's avatar
learner03
Post Partisan
2 years ago

Timestamp format

I have a last refresh timestamp on each report.

For that I am using below query-

let
Source = DateTime.LocalNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Inserted Date" = Table.AddColumn(#"Converted to Table", "Date", each DateTime.Date([Column1]), type date),
#"Inserted Time" = Table.AddColumn(#"Inserted Date", "Time", each DateTime.Time([Column1]), type time),
#"Renamed Columns" = Table.RenameColumns(#"Inserted Time",{{"Column1", "DateTime"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "DateTime MyZone", each DateTime.From ( [DateTime] ) + #duration(0, +10,0,0))
in
#"Added Custom"

 

This shows last refresh time in power Bi service in local time. I use "DateTime MyZone" in a card visual to show the date/time. But in service, it shows the date time as month first  then date (American format) but I nedd Date/month/Year and time.