How to compare dates

[Anonymous]

Hello, I want to create a custom table based on a time comprasion.

I have a table that lists item sold from 01/01/0217 up until today.

I want to create a table with the item sold only in 2017.

My idea would be to do something like

LastYear=CALCULATETABLE('Table';Table[date]<01/01/2018).

However this does not work.

[Arentir · Accepted solution]

Hi @Anonymous

Try LastYear=CALCULATETABLE('Table';Table[date]<YEAR(2018,1,1))