The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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