Get a 'Count' of rows in a particular Table, based on matching condition in two other tables

Hi, I have found it very challenging to explain this scenario. I will try my best using 'expected outcome'. See links below. The expected outcome is in Table C, Column name = 'Commit counts'. All...

excel

Formulas and Functions

power bi

Lorenzo
Dec 01, 2022
Hi leo1982

Given the size of your actual tables I didn't look at a formula based solution but Power Query
Note that I renamed your tables (for clarity on my side) in the attached file
This seems to do what you expect. Let's see how it goes with your actual data set...

leo1982

Copper Contributor

Dec 01, 2022

Anyone can help please?

Lorenzo

Silver Contributor

Dec 01, 2022

Hi leo1982

Given the size of your actual tables I didn't look at a formula based solution but Power Query

Note that I renamed your tables (for clarity on my side) in the attached file

This seems to do what you expect. Let's see how it goes with your actual data set...

leo1982
Copper Contributor
Dec 01, 2022
Thank you so much for your help. I will give this a try and report back shortly.

Forum Discussion

Get a 'Count' of rows in a particular Table, based on matching condition in two other tables