Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to filter a date field in a filter pane for the last 4 weeks of data.
=DATE([Survey Start Date], 'YYYYMMDD')>Date(Weekstart(WeekName($(=max([Survey Start Date])),-4)),'YYYYMMDD')
when i add this condition to the filter, its not filtering on the right values.
Try this
=Date([Survey Start Date]) >= WeekStart(Max([Survey Start Date]) - 28)
Or may be with calculated dimension
=If([Survey Start Date] >= WeekStart(Max([Survey Start Date]) - 28), [Survey Start Date])