Sunday, January 31, 2021

Power Query - dCalendar Hour DIM_Horario

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

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE