showing a value based on the sum of data in a specific date range

[Eman1501]

I am trying to make a budgeting app and I want to have a page that shows a value of all the expenses made within a specific date range. Is there a way to do this? 

[WillowMobileSys]

Absolutely!

Use the SUM() function with a SELECT() that grabs the column to be summed from all of the filtered rows, like this:

SUM(SELECT(Expenses Table[Sum Column],
           AND([Date] >= "<<start date>>", [Date] <= "<<end date>>"))

 NOTE:  Replace "Expenses Table" with the name of your table where the expenses are saved
               Replace [Sum Column] with the name of your column
               Replace <<start date>> with the start date of the range
               Replace <<end date>> with the end date of the range

There are likely details specific to your use case.  If so, please provide and explain.

I hope this helps!

[Eman1501]

Thanks for the answer, I tried using that and I keep getting this error response "Cannot compare List with Date in (Monthly Expenses[Expense Date] >= "01/01/2025 00:00:00")"