Answered

Max values from collection

(0) Share

Report

Posted on by Kepcla

Hi experts!

I have a source with this items :

And I want to create a collection only with maximum values (red values) , I try with "AddColumns", but it gives me the max for every row...maybe using "group by"...but I don´t know how!

it should be like this:

Categories:

General Questions

All responses (3)

Answers (1)

Kepcla on at

Like (0)

Report

Re: Max values from collection

I tried with GroupBy and AddColumns, but your solution @v-qiaqi-msft is more practical and fast.
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Max values from collection

HI @Kepcla,

Please create this collection as below:

DropColumns(AddColumns(GroupBy(colG,"Site","Type","SG"),"Max",Max(SG,To)),"SG")
eccountable_dev 18 on at

Like (0)

Report

Re: Max values from collection

Im just starting but my initial thoughts are to use the max of every record as a comparative to create a different collection that only shows the data like in your second picture. I figure you could use a button, on change event or anything of the sort to check and collect.

again I'm still pretty new at this but that is how I might go around the problem you are having. Someone probably has a more efficient and clearer answer then myself.