Forum Discussion
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!
each Table.RowCount(xxxx) where xxx is the name of the table
1 Reply
- HotChilli
Community Champion
each Table.RowCount(xxxx) where xxx is the name of the table