Show maximum value based on another category column

(0) Share

Report

Posted on by SriKandimalla

Hello PowerApps Community,

I have a similar Dataset as below which I am trying to show in my PowerApp

ID	Category	Name
1	Category A	Sample name 1
2	Category A	Sample name 2
3	Category A	Sample name 3
4	Category B	Sample name 4
5	Category B	Sample name 5
6	Category C	Sample name 6
7	Category C	Sample name 7
8	Category C	Sample name 8
9	Category C	Sample name 9

From the above source table I only want to show each category only once with the highest ID for that category, and also the corresponding name. For example see the below table.

ID	Category	Name
3	Category A	Sample name 3
5	Category B	Sample name 5
9	Category C	Sample name 9

I appreciate if anyone can help. Thanks in Advance

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Re: Show maximum value based on another category column

Hi @SriKandimalla ,

I did a demo for you.

1\ This is my list .

2\ Add a gallery control and set its Items property to:

Filter(ForAll(Distinct(LIST154,Category),First(Sort(Filter(LIST154,Category=Result),ID,Descending))),!IsBlank(ID))

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.