Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I can insert a blank row using this code:
= Table.InsertRows(Source, 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})
but the zero inserts at the beginnng of the table.
I would like to insert the blank row at the last row.
I tried using Table.PositionOf(Source, RowAsRecord) but do not know how to extract the RowAsRecord.
Table.LastN(Source, 1) // locates the row, but is not a record type.
Finally I tried converting it to a record, but is not in the format [name="", value=""]
Record.FromTable(Table.LastN(Source, 1))
Hence, this code does not work:
= Table.InsertRows(Source,
Table.PositionOf(Source,
Record.FromTable(Table.LastN(Source, 1))),
{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))})
Please advise. Thank you!
Solved! Go to Solution.
Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.
--Nate
Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.
--Nate
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
58 | |
53 | |
26 | |
16 | |
9 |