Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to compare dates

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. ...
Need Help
  • Arentir's avatar
    Arentir
    7 years ago

    Hi Anonymous

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

Arentir's avatar
Arentir
Resolver III
7 years ago

Hi Anonymous

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