Using the GroupBy Function for a changing, but specific date in another table?

[kressb]

Hello,
Can you use "Group By" Function for a specific date?

Ex, I have table like this:

I used GroupBy to get 1 Line, Per Date, Per Person:

Now I want to have a GroupBy Table just like the above, but for only the date that matches a date in a 2nd Table.

Ex: Table2:

GroupBy with Table2[Date]:

[amitchandak]

@kressb , you need to filter all measure using

https://docs.microsoft.com/en-us/dax/treatas-function

or measures like

new Number = Calculate([Number], filter(Date, Date[date] in values(Table2[Date])))

new Avg no Number MTD= Calculate([Avg no Number MTD], filter(Date, Date[date] in values(Table2[Date])))

[kressb]

I use the "GroupBy" Function in PowerQuery.. there doesn't seem to be a way to use formulas?
there's just drop downs.