countrows matching date

[1984]

Hi Helpful Community

I have two related tables table one with a column MMM-YY (Jan-Dec) and the other table 2 with raw rowdata. I would like to create a second column in table one that counts the rows in table two returning the value next to each month for the same month.

So for example Jan-24 count how many match Jan-24 from table two 

If any further info is required do let me know as I can supply, thanks in advance

[Anonymous · Accepted solution]

Hi @1984 ,

Based on the information you provided, I created an example. You can follow the steps below:

1.Add a column to count the number of rows in Table2.

Number of Rows = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[Column1] = 'Table'[Date]))

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

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