cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pandadev
Post Partisan
Post Partisan

Create a summary table from 60 tables not all in same format

Hi I have 60 tables that I need to create a summary table from , the tables are not formatted the same. With different amounts of columns and named columns. But each table has a Column called QC Check . And each table has a different name for this column. Is there a way to build a table based on this column , so i can do a count of each QC check. So I can show how many rows there are for each named QC check, 

Table QC_1 has 50 rows and the name in the QC Check column is QC Check 1

Table QC_2 has 120 rows and the name in the QC Check column is QC Check 2

Table QC_3 has 75 rows. and the name in the QC Check column is QC Check 3

 

I would like a table creating like

QC Check - Total

QC Check 1   50

QC Check 2   120

QC Check 3    75

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Pandadev , Not very clear

Try like

union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Pandadev , Not very clear

Try like

union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Thanks that worked perfect , I just changed "Table" to "QC Check" as noticed that was the column header name , same for "Rows"

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors