Filter Equation Help

1

Hi all,

I can’t quite figure out the correct formula and would appreciate some help.

I’m trying summarize the total of a column called “revenue” if the “check in” dates (another column) are equal to May 2024.

This data lives in another table called “2024 Reservations”.

Thanks in advance!

2

Hey Garrett!
Perhaps something like this would work for you

[2024 Reservations].Filter([Check In].Year() = 2024 AND [Check In].MonthName() = "May").Revenue.Sum()
2 Likes