Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |