Peter Kennedy on 23 Aug 2021 01:49:09
Currently a measure that calculates a date (for example "Customer First Order Date" can be placed on a visual and filtered using SPECIFIC date values with filters such as "on or before <date>", "after <date>", etc.
It would be great if Relative date filtering could also be made available for date measures.
This would enable (for example) a "First Order Date is in the last 4 weeks" type filter to be applied.
Currently we can only specify a hard-date filter to achieve this (e.g. "First Order Date is on or after 01 July 2021"), which does not "move with the times".