Forum Discussion
Using the GroupBy Function for a changing, but specific date in another table?
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]:
2 Replies
Anonymous , 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])))
