Filter Equation Help

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!

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

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.