Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

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...
Need Help
Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

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.

Gabry's avatar
Gabry
Icon for Super User rankSuper User
2 years ago

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