Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have created a Totals table to combine some totals from 4 different data tables that are all related to my "Contacts" table.
I'm new to Power BI, so trying to figure out how to do this....I basically have 4 custom tables...
1) Auctions
2) Retail
3) B2B
4) Personal
I want to put record counts of each of these into it's own table if possible. Or, if there's a better way, please let me know. In Power Query, I have the Totals table created, but I can't seem to get it total up the record counts on any of the tables. I tried
= Table.AddColumn(#"Converted to Table1", "Custom", each Count(auction)) for the Auction table but I'm getting "Expression.Error: The name 'Count' wasn't recognized. Make sure it's spelled correctly."
Any help is greatly appreciated!
Solved! Go to Solution.
each Table.RowCount(xxxx) where xxx is the name of the table
each Table.RowCount(xxxx) where xxx is the name of the table
User | Count |
---|---|
98 | |
76 | |
69 | |
53 | |
27 |