Forum Discussion
countrows matching date
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
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.
1 Reply
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.