Hi, can anyone provide the right column formula to SUMIf rows from another table if its date column is between [daterange controller] ? Preferably using Filter function, because I need to add multiple criteria as well. I tried Matches formula but in each version it returns 0. (Even if I set up a d…

I think this is what you were looking for :slight_smile: For the Price Tasks.Filter([Done date]>=[daterangepicker 1].First() AND [Done date]<=[daterangepicker 1].Last() AND Epic.[Epic Name]=thisRow.[Epic Name]).Price.Sum() And for the Duration Tasks.Filter([Done date]>=[daterangepicker 1].First(…

Hi @Balint_Drahota - Welcome to the community! Can you take a look at this and see if it helps you? I created a date range controls and this is the formula I used for SumIf thisTable.Filter(Date.Matches([Date Range picker]) andItem=thisRow.Item).Cost.Sum() I also added a filter ot the “items” ta…

I applied your 2nd formula in the Epics table’s Price in date range column, but still returns 0 for all row. Maybe the problem is that the display column is not the same as in the “Tasks” table. Please edit the formulas in Price in date range and the Duration in date range columns.

I’ve edited my previous comment to be more informative, including sample doc :slight_smile:

Thanks so much! I didn’t know that I should use First and Last with date ranges, and NOT Min and Max.

You’re welcome :wink: A tiny note : Min() and Max() are used with numbers :wink: First() and Last() is generally for everything that is not a number :wink: (like here with the dates :wink: ) But it can depend of the use case and the expected results

SUMIf date is between [daterange controller]

Superhuman Ask the Community

mallika November 1, 2019, 7:06pm 4

Can you share a sample doc here and I can work directly in that with you? Thanks !

Topic		Replies	Views
Please help with formula - sum with a data range filter Ask the Community	2	258	February 12, 2024
How to lookup and sum values of another column? Ask the Community	4	1147	September 26, 2022
Sumif using two variables? Ask the Community	11	2741	October 19, 2019
Count/sum/avg values based on the date range control Ask the Community	3	321	December 29, 2023
Dates within a sum formula Ask the Community	2	704	May 25, 2020

SUMIf date is between [daterange controller]

Related topics