Aggr(Max(date) within If statement brings the wrong result

PP_12 — Mon, 01 Aug 2022 11:05:34 GMT

Hi,

I would like to know if it is possible to highlight the max dates of an each ID and still have the rest of the dates remain in the table. I would my results to be like table 1 below. I have created a measure column with aggr(max(date1),ID) and it brings correct results with nulls but would like to avoid creating this coloumn as I need all dates. I put this inside an IF statement then I get the wrong results (table 2).

Table 1 - Desired Result

ID	Date1
124	30/12/1996
124	24/01/2021
125	06/10/2012
125	15/05/2022
127	09/08/1990
127	29/03/2013

Using If(Aggr(Max(Date1),ID),yellow()) within the column background color expression -I keep getting the wrong result. I get the result below. Could I please get help with this?

Table 2 - Incorrect Result

ID	Date1
124	30/12/1996
124	24/01/2021
125	06/10/2012
125	15/05/2022
127	09/08/1990
127	29/03/2013

Kind regards,

Penny

Re: Aggr(Max(date) within If statement brings the wrong result

justISO — Tue, 02 Aug 2022 06:30:07 GMT

Hi, try this:

If(Date1 = Aggr(nodistinct Max(Date1),ID),yellow())

Re: Aggr(Max(date) within If statement brings the wrong result

PP_12 — Wed, 03 Aug 2022 09:01:39 GMT

Great, thank you. It looks like it works will need to try in my main application

topic Re: Aggr(Max(date) within If statement brings the wrong result in App Development

Aggr(Max(date) within If statement brings the wrong result

Re: Aggr(Max(date) within If statement brings the wrong result

Re: Aggr(Max(date) within If statement brings the wrong result