Forum Discussion
Power Query - add column that counts rows from other table
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
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.
3 Replies
kroman , do the merge operation and the expand take count of URL column only
Sorry, I am still quite new to Powr BI - can you give more details please
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.
