Return rows for Max date and specified category

[av9]

Hi

From the table below I am trying to build a subset of this table that will show the last email by date for a specific email type. So in this example I need the latest email for type = Important.

So my results should look like this:

any ideas how I can achieve this?

[amitchandak · Accepted solution]

@av9 , Create this measure for email, or if required for all other columns

calculate(max(Table[email ID]), filter(Table, Table[Date] = calculate(max(Table[Date]), allexcept(Table, Table[Customer name]))))

[Ashish_Mathur]

Hi,

Share the link from where i can download your Excel file.