Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
saturation
Frequent Visitor

Totals Table in Power Query - Need Help!

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!

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

each Table.RowCount(xxxx)   where xxx is the name of the table

View solution in original post

1 REPLY 1
HotChilli
Super User
Super User

each Table.RowCount(xxxx)   where xxx is the name of the table

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors