Forum Discussion

saturation's avatar
saturation
Frequent Visitor
7 years ago
Solved

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's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion

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