The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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