How do I create a measure for: 'sum all revenues if the year = 2022'

[james_wood]

I have close dates for items in a column (see snap below), some of which are in 2022. A separate column has revenues for each item. How do I create a measure that calculates the total revenue for all items that were closed in 2022?: 

[amitchandak · Accepted solution]

@james_wood , Measure

calculate(sum(Table[Revenue]), filter(Table, year(Table[Close date]) = 2022))

or

calculate(sum(Table[Revenue]), filter(Table, year(Table[Close date]) =year(Today()) ))