cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
djh Frequent Visitor
Frequent Visitor

Dates in Filter function

I'm wanting to look at some analysis on my table before  certain date, but i'm getting an error.

 

I'm trying to use FILTER, but it won't seem to allow a date criteria. =FILTER(Table, Date<"01/06/2018") and FILTER(Table, Date<"VALUE(01/06/2018")) don't seem to work.

 

Any suggestions?

 

 

1 REPLY 1
Super User
Super User

Re: Dates in Filter function

FILTER returns a table as an output, are you using it in CALCULATE to pass filters, or in some other way?
Measure can only return a scalar value, same with calculated column
Syntax wise - it should look like this

 FILTER(Table, Table[Date]<"01/06/2018")