Sum of rows in Datatable

(0) Share

Report

Posted on by Jyothi1

Hi Team,

sum of rows based on same column in between 2 dates

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Jyothi1

Try this,

Sum( Filter( YourDataSource, YourDateColumn >= StartDate && YourDateColumn <= EndDate ), YourColumnToSum )

Refer this thread : Solved: Sum all values between two dates - Power Platform Community (microsoft.com)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Jonathan Manrique 2,687 on at

Like (0)

Report
Hi @Jyothi1

You can use this condition to establish the range of products and the right amount

Sum(Filter(date < DateColumn and date >DateColumn2),Amount)

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
Jyothi1 39 on at

Like (0)

Report

Thanks for the quick response but it didnt work. Ok I will explain my problem. I have 2 date pickers. I should calculate the total amount of milk given by one animal of that particular animal Tag number. Here I have to use Tag number as the reference.

Was this reply helpful? Yes No
FazalUrrehman 131 on at

Like (0)

Report

Can u provide with the column names along with screenshots which will help us to understand better

Was this reply helpful? Yes No
Jyothi1 39 on at

Like (0)

Report

Screenshot 2023-1...

Was this reply helpful? Yes No
FazalUrrehman 131 on at

Like (0)

Report
Ok Try This
On Visible
ClearCollect(Collection1, Distinct( DatasourceName, TagId ));
On Change of any of the datepickers
Clear(Collection2);
ForAll(Collection1,
Collect(Collection2,
{
TagID : Value,
Milk : Text(Sum(Filter(Datasource,TagID=Value && DateColumn > Datepicke1.SelectedDate && DataColumn <DatePicker2.SelectedDate ),Milk))
}
);
Try this and let me know if there is any issue in the code

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Jyothi1

Assuming your data source is named MilkData, your date column is named Date, your milk amount column is named MilkAmount, and your tag number column is named TagNumber.

Sum(
Filter(
MilkData,
Date >= DatePicker1.SelectedDate && Date <= DatePicker2.SelectedDate && TagNumber = "YourAnimalTagNumber"
),
MilkAmount
)

Thanks!

Was this reply helpful? Yes No
Jyothi1 39 on at

Like (0)

Report

Hi,
Still getting error.

Screenshot 2023-1...

Was this reply helpful? Yes No
FazalUrrehman 131 on at

Like (0)

Report

U have missed two brackets at the end before the closing curly bracket

Was this reply helpful? Yes No