Skip to content

Instantly share code, notes, and snippets.

@aabundez

aabundez/data_last_refreshed.pq

Created January 20, 2021 04:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aabundez/50d601d582a460eb024ed5720aea8213 to your computer and use it in GitHub Desktop.
Save aabundez/50d601d582a460eb024ed5720aea8213 to your computer and use it in GitHub Desktop.
Download ZIP
PQ for Data Last Refreshed
Raw
data_last_refreshed.pq
let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),-8)}}), //PST is UTC-8
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date Last Refreshed", type datetimezone}})
in
#"Changed Type"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment