Comparing Month and Year of Two dates

[Chrism123]

Hi,

I hope someone can help me with this problem.

I would like to compare Year and Month of two dates but I only know how to compare either month or year.

=CALCULATE('Measure'[Sales]+'Measure'[Backlog];

FILTER(all(date[Order Date]);

month(date[Order Date])=month([Last Batch Date])))

Thanks!

[jthomson]

You should just be able to add the same syntax you've used for the month section for the year as another argument in your calculate function

[Chrism123]

Hi, I already tried this, but it I get an error because there is only a maximum of 2 arguments allowed for the FILTER-function.

[jthomson · Accepted solution]

Maybe try month(date[Order Date])=month([Last Batch Date])&&year(date[Order Date])=year([Last Batch Date]) instead?

[Chrism123]

Thank you! 🙂 I think that works!