Return in a table the number of rows of each queries

[FredLEGUEN]

Hi,

Is there a way to return in a table the number of rows of each queries ?

I want to have the result displays in the pane in a single report.

Is it possible ?

Number of rows for each query

Ok, I can create a group by query for each query but it's a waste of time.

[Stachu · Accepted solution]

you can do it with #shared, you will just have to filter your queries in #"Filtered Rows"

let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source),
    #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Name] = "D35" or [Name] = "D39")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "NrOfRows", each Table.RowCount([Value])),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Name", "NrOfRows"})
in
    #"Removed Other Columns"

[FredLEGUEN]

Thanks @Stachu 

I knew #shared to display all the functions but I didn't know this function display also the current queries.