Biaccountantdotcom.files.wordpress.com



Source: - Mark WalterReplace the M code in an empty table with the following block:----------------------------------------let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCslPSaxUcEksSbVSio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Desc = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Desc", type text}}), #"Add UTC Time" = Table.AddColumn(#"Changed Type", "UTC Format", each DateTimeZone.UtcNow()), #"Renamed Columns" = Table.RenameColumns(#"Add UTC Time",{{"UTC Format", "Date Time"}}), #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date Time", type datetimezone}}) in #"Changed Type1"---------------------------------------*Note: In the below version, I reference a [UTC Offset] column in my location table 'LOCKEY'. I use this location table to list the UTC offset of each location depending on the locations time zone.In Power BI Desktop, create the following measure:---------------------------------------UpdateTime (w TZ) = VAR UTC=CALCULATE(MIN(TimeUpdate[Date Time]))VAR OFFSET=CALCULATE(MIN(LOCKEY[UTC Offset]))RETURNUTC+(OFFSET/24) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download