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 th...
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])))
I use the "GroupBy" Function in PowerQuery.. there doesn't seem to be a way to use formulas?
there's just drop downs.