Power Query - add column that counts rows from other table

[kroman]

Hi All

I have 2 tables: AllFiles (Url (unique) )  and  FilesAccessed (Urls, AccessDate)
I need to add custom column to AllFiles that would show how many times particular file was accessed. So something like         "Table.AddColumn(#"Removed Columns", "TotalAccessed",
       each Table.RowCount(Table.SelectRows(FilesAccessed, each [Urls] = [Url] ))) " 

But getting error on it. 
Can anybody show me how it shouhld be done?

Thanks

[v-henryk-mstf · Accepted solution]

Hi @kroman ,

According to your description, refer to the following steps:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@kroman , do the merge operation and the expand take count of URL column only

[kroman]

Sorry, I am still quite new to Powr BI - can you give more details please