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...

Resources