Help - Creare la colonna "Risultato finale" con power query partendo dalla colonna "Dati"

[emafiorito]

Salve.

Qualcuno sa dirmi come faccio con power query a partire dalla colonna "Dati" per avere la colonna "Risultato finale"?

Vi ringrazio anticipatamente di cuore!

Saluti!

Emanuele

[lbendlin · Accepted solution]

There is a standard function called "Fill Down".

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcvV19At19XFVitWJVtLCQfo6hoS4+mMI+3k6+/s4Ygi7ubq4BgGl8BoJJGMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Dati = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Dati", type text}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","*",null,Replacer.ReplaceValue,{"Dati"}),
    #"Filled Down" = Table.FillDown(#"Replaced Value",{"Dati"})
in
    #"Filled Down"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".