Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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
)
@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
)
Thanks that worked perfect , I just changed "Table" to "QC Check" as noticed that was the column header name , same for "Rows"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |