let
vBinary = "bc+9DYAgFATgXagt+FeG0MqOUJBg1EYToxM5iosJUpl7zd3l6857xlnD+piOa44p5i1YaHxOSiWpilRNqiHVfrotz52H/KhF6pAckuCECcLKmTEeacqtKikkjWSQLFKLVA4M+3oW0pUckORIAkkiqT+FFw==",
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(vBinary, BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Hora = _t, Turno = _t, Column1 = _t]),
Step01 = Table.RenameColumns(Source,{{"Column1", "Nivel"}}),
Step02 = Table.AddColumn(Step01, "TurnoNivel", each [Nivel] & " - " & [Turno]),
Step03 = Table.TransformColumnTypes(Step02,{{"Hora", Int64.Type}, {"Turno", type text}})
in
Step03
No comments:
Post a Comment