topic Re: How to find a variable based on max date and max sales (2 conditions) without any preloading in App Development

How to find a variable based on max date and max sales (2 conditions) without any preloading

Anonymous — Sat, 16 Nov 2024 07:06:10 GMT

Hi all,

I have the table as follows:

I would want the fruit name with the most sales for the latest date. In this case, 'apple' should be my answer.

Thanks!

OmarBenSalem — Fri, 07 Dec 2018 11:07:52 GMT

Create a KPI with this measure:

FirstSortedValue(fruit, -aggr( max ({<date={"$(=max(total date))"}>} sales),date))

Result:

Anonymous — Mon, 10 Dec 2018 04:09:26 GMT

Thanks Omar