Forum Discussion
Relative date filter for week(mon-sun)
Hi, I have relative date filter set up for calendar week. The problem is that week is Sunday - Monday. If I try to set to just a week option it becomes just moving moving week by day what is even w...
As you can check here Microsoft Idea
I think you can't do it using that filter. You should do it with a calculated column or measure but not using the "relative date filter pane" as i Know
Gabry Since I can only create measures and not calculated columns it would be great if you know how I can do it with a measure.
Since as far as I know you cant use measures in a filters.Maybe you can do something like this
Measure = if(selectedvalue(date)>today()-7,1,0) then put the filter always on 1
just thinking, you have to adjust and test if it works
Gabry I tried and it doesnt seam I can use it.
I think it has to be normal or calculated column.
Unless there is something else I can try.
