Hi, I need to return all months that occur before the period selected in the filter (for example, November 2025). Could you please help me achieve this?
Hi @Narayana1
Create a date parameter for users to select a reference period (e.g., November 2025), then use a calculated field with truncDate to identify and return all months before that period. Apply to the parameter to date field as a filter to show prior months exclusively. Please refer the following images for reference.
