How do I count the number of records for a merge without expanding?

[arpost]

I'm sure this is super simple and feel like I've seen something like this before, but I am performing a merge between two tables and want to get a count of the number of merged records WITHOUT expanding. When I select the table, I can see all of the results but can't figure out what M code to use to access the inner table.

[BA_Pete · Accepted solution]

Hi @arpost 

Try this in a new custom column:

Table.RowCount([Fact Order])

Pete

[arpost]

Thanks, @BA_Pete! I could've sworn I did that before. 🤔 Ah, well. That did it. Thanks again.