Count rows from another table

Hi Anonymous ,

We can use the following steps to meet your requirement.

1. In Power Query Editor, we need to add a date column and a week column.

2. Create three measures.

Today number of Group = 
var _today = TODAY()
return
CALCULATE(COUNT('Table'[Group]),FILTER('Table','Table'[Date]=_today))

This week number of Group = 
var _thisweek = WEEKNUM(TODAY(),2)
return
CALCULATE(COUNT('Table'[Group]),FILTER('Table','Table'[Week of Year]=_thisweek))

Last week number of Group = 
var _lastweek = WEEKNUM(TODAY(),2)-1
return
CALCULATE(COUNT('Table'[Group]),FILTER('Table','Table'[Week of Year]=_lastweek))

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.