Counting rows from one table and putting the results into another table

[Anonymous]

I have a table that I am directly connected to via SQL server and a table that I made.  See screenshots, the one on the left is the directly connected table, the one on the right is the one I made.

  

Is there a way for a cell in the table on the right to be a count of the datetime field on the left.  For instance, the StatementDupe1 review name on the right has a count of 313 over the last 30 days, which I was able to get from the directly connected table.  I manually put that number in the table on the right, which is the total count of the rows on the left table.  However, I would like that cell with 313 to automatically count the rows from the table on the left so I don't have to update it manually.  The same thing goes for the rest of the review names in the table on the right, they are in their own tables and I would want to have the counts updated automatically.  I'm not sure if this makes any sense.

[Anonymous]

All of those review names in the table on the right are separate tables.  So, I want the count column in the table on the right to count the rows in each of those tables automatically.  Each cell in the table on the right would be a count of a different table.    

[CoreyP]

Do you have a specific requirement that these tables need to be separate queries Power Query or is the requirement that you just need to show a table visual in the report that displays the automatically updated counts?