Forum Discussion

czuniga's avatar
czuniga
Icon for Helper III rankHelper III
6 years ago
Solved

Adding a column to a calculatedtable groupby

I created calculatedtable "B" with groupby function from another table "A". Table "A" has a date field. I'd like to add the most recent dates from table "A" for each group in table "B".    Any id...
  • az38's avatar
    az38
    6 years ago

    czuniga 

    yes, sorry

    Column = CALCULATE(MAX(TableA[Date]), FILTER(ALL(TableA), TableA[group]=EARLIER(TableB[group])) )