Trying to get the max and min values in a simple table and sum the result

(0) Share

Report

Posted on by bobgodin

380

I have a simple Sharepoint list called MeterReadings feeding a Gallery in a Powerapp and the data looks like this:

meterref	reading
18367	100.6
18367	159.7
18368	38.28
18368	46.5
18379	67.77
18379	99.52
18585	4.31
18585	6.42
18585	36

I think I need to do a groupby or a Forall but I can't seem to find the correct syntax or way to achieve thisBasically I want to get the max and min values for each meterref and then sum all those values - and the total should be 120.77

any help greatly appreciated

cheers

Bob

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 152,851 Most Valuable Professional on at

Like (0)

Report
Re: Trying to get the max and min values in a simple table and sum the result

Hi @bobgodin ,

The formula you described is below, but the total of all maximum and minimum values is 552.68

Sum( AddColumns( GroupBy( SPListName, "meterref", "Data" ), "MaxVal", Max( Data, reading ), "MinVal", Min( Data, reading ) ), MaxVal + MinVal )

if you meant Average, this is 138.17

Average( AddColumns( GroupBy( SPListName, "meterref", "Data" ), "MaxVal", Max( Data, reading ), "MinVal", Min( Data, reading ) ), MaxVal + MinVal )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report

Re: Trying to get the max and min values in a simple table and sum the result

@WarrenBelz thanks Warren - not quite right - I may have not explained it clearly
I want to take the min and max values (for example with meterref 18367 - the values are 100.6 and 159.7 and get the difference - in this case 59.1, then do the same for all the other meterefs and the sum the differences - it's about meter usage so we're adding up the difference between each meter read and then summing the difference (usage) to get an overall usage for that client. Hope this is clearer now cheers

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,851 Most Valuable Professional on at

Like (0)

Report
Re: Trying to get the max and min values in a simple table and sum the result

Hi @bobgodin ,

It is actually 130.76

Sum( AddColumns( GroupBy( SPListName, "meterref", "Data" ), "ValDiff", Max( Data, reading ) - Min( Data, reading ) ), ValDiff )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No