Not Current Month of Current Year

[TimmK]

How can I use CALCULATE or FILTER to get all values except of the current month and year?

For example:

Current month and year today is April 2021.

=> Desired result is all values but not for April 2021

It should always refer to the current month and year automatically.

[amitchandak · Accepted solution]

@TimmK , Try a measure like

CALCUALTE(Sum(Table[Value]) , filter(Table, eomonth(Table[Date],0) <> eomonth(today(),0)))

or with date table

CALCUALTE(Sum(Table[Value]) , filter(Date, eomonth(Date[Date],0) <> eomonth(today(),0)))