Dynamic Date within Beast Mode
I have a Beast Mode that is grouping transactions based on their date: CASE WHEN OrderHeaderLocalDate >= '02/27/2024' THEN 'Since Changes CY' WHEN OrderHeaderLocalDate >= '08/01/2023' AND OrderHeaderLocalDate <= '02/26/2024' THEN 'Prior YTD CY' WHEN OrderHeaderLocalDate >= '02/27/2023' AND OrderHeaderLocalDate <=…
