formula for calculating a new column with the most recent date per department

[EVIJ]

Hello,

I need some help with the formula for calculating a new column with the most recent date per department.

This is what I would like to have as my outcome:

The first and second column are included in my table, but how do I calculate the third column (the most recent date) in Power BI? Thank you. 

Kind regards,

Ellen

[amitchandak · Accepted solution]

@EVIJ ,

Most recent date =calculate(max(Table[date]), filter(allselcted(Table), table[department] = max(table[department])))

[v-lionel-msft · Accepted solution]

Hi @EVIJ ,

If you want a calculated column, you can do this.

Column = 
CALCULATE(
    MAX(Sheet2[Date]),
    ALLEXCEPT( Sheet2, Sheet2[Department] )
)

Best regards,
Lionel Chen

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

[amitchandak · Accepted solution]

@EVIJ ,

Most recent date =calculate(max(Table[date]), filter(allselcted(Table), table[department] = max(table[department])))