Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Thank you @Anonymous that was easy!
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 3 |