Get a count of rows from multiple tables by researcher

[Pandadev]

Hi I am trying to create a summaized table , based on multiple tables which are all in the same format. I am trying to get a count of rows based on the researcher for each table.

So the table will look like

Table Name  -       Researcher - Total

Futures 0-2 days   Dave             33

Futures 0-2 days   Bob               127

Futures 0-5 days   Bob               125

Futures 0-5 days   Mark             99

I tried to look at creating a table using this code

otals =

Var Sum_0to2 = SUMMARIZECOLUMNS(

'Futures 0-2 days'[Researcher],

"Total",SUM('Futures 0-2 days'[Serial Number]),

)

var Sum_0to5 = SUMMARIZECOLUMNS(

'Futures 0-5 days'[Researcher],

"Total",SUM('Futures 0-5 days'[Serial Number]),

)

var Sum_6to14 = SUMMARIZECOLUMNS(

'Futures 15-31 days'[Researcher],

"Total",SUM('Futures 6-14 days'[Serial Number]),

)

any help would be much appreciated

var Sum_15to31 = SUMMARIZECOLUMNS(

'Futures 15-31 days'[Researcher],

"Total",SUM('Futures 15-31 days'[Serial Number]),

)

[parry2k]

@Pandadev you should append these tables in Power QUery and then it should be straight forward to visualize. Maybe add a source column in each table to tag the rows so you can visualize it by source.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Pandadev]

Is there another way to do this , as I have found some of the tables do not have the same structure. number of columns so I am unable to use the append option .

[Pandadev]

Thanks how would I do this , by creating a new table and appending selected tables to this new table , as the tables are updated daily via SQL. and I need to create a summary table based on selected tables

[parry2k]

@Pandadev yes append table in power query and on refresh, all these tables will get new data from SQL

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡