Forum Discussion
Converting hierarchical data
Hello, I'm relatively new to power query. I've been trying to convert this table N Actividad 1 Asegurar reportabilidad 2 Crear dashboard en Power BI 2.1 Creació...
= let a=Record.FromTable(#table({"Name","Value"},Table.ToRows(Table.TransformColumns(Source,{"N",Text.From})))) in Table.FromColumns(List.Zip(Table.ToList(Source,each let b=Text.Split(Text.From(_{0}),".") in List.Transform(List.Positions(b),each Record.Field(a,Text.Combine(List.FirstN(b,_+1),"."))))))