Drill down Rows

[Addora]

Hello there,

please, I ask for some support at Power BI, I'm new at that fabulous application. I got data from a XML file >> then edit >> as shown I ask for how can I drill or split each line in an autonomy row then fill down the other rows, is that applicable in Power BI, I hope that, please

 

[ralliartur]

I don't know if i've understood correctly the request, but i can propose this:

My table:

aaa

Header 1 Line1 2 Line2 3 Line3

<tbody>
</tbody>

In power query:

let    
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Transformation = Table.AddColumn(Source, "ToRows", each Table.PromoteHeaders(Table.FromList(Text.Split([aaa],("#(lf)")))))
in
    Transformation

At the end:

aaa	ToRows
Header 1 Line1 2 Line2 3 Line3	Table

<tbody>
</tbody>

ToRows column contains:

Header

1 Line1

2 Line2

3 Line3

<tbody>
</tbody>

 

[MarcelBeug]

My proposal:

let
    Source = Excel.CurrentWorkbook(){[Name="MultipleLineTable"]}[Content],
    MultipleLineTable = Table.TransformColumnTypes(Source,{{"Column with lines", type text}, {"Other column1", type text}, {"Other column2", type text}}),
    LinesFromText = Table.TransformColumns(MultipleLineTable,{{"Column with lines", Lines.FromText, type text}}),
    Expanded = Table.ExpandListColumn(LinesFromText, "Column with lines")
in
    Expanded