Forum Discussion
How to make date columns filterable
My data sheets span from 2016 to 2022，I filter the data behind by the previous time period, such as 2016 to 2018，The table name is "ALLORDER",Measures below _Result =
var tb1 = FILTER(VALUE...
Hi RuyiLuo
Is your date column filtered to exclude 2016? As you can see from your measures that your measures are fixed-years, make sure that you include these fixed years in your year filter. and can you provide some sample data or pictures so that we can better advise you?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I‘m sorry,I don't understand "make sure that you include these fixed years in your year filter" mean,The table is a trader order,like this,
the year filter is date hierarchy,
The other column can filter ,except date column