Forum Discussion

leo1982's avatar
leo1982
Copper Contributor
Nov 29, 2022
Solved

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's avatar
    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...

Lorenzo's avatar
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's avatar
leo1982
Copper Contributor
Dec 01, 2022
Thank you so much for your help. I will give this a try and report back shortly.

Resources