Total rows in a table as input for PQ how to deal with it?

Hi Bart,

Totals is the property of the table, you can't check it directly in the query. As workaround could be:

In any cell check the totals for your table like

=Table1[[#Totals],[a]]

it returns something if Total row exists and error if not

In Name Manager add the name for this cell, i took "CheckTableTotals"

Using it in your query check if Total row exists or not

    //Check if Totals row exists in the Table and remove it then

    SourceTotals = Excel.CurrentWorkbook(){[Name="CheckTableTotals"]}[Content],
    TestForError = try SourceTotals{0}[Column1],
    RowsToRemove = if TestForError[HasError] then 0 else 1,
    RemoveTotals = Table.RemoveLastN(Source,RowsToRemove)

    //Continue without Totals

Here i removed Total row from resulting table if it exists