Show only 6 weeks up to selected dates by parameter

Published: 01 Jun 2023
Last Modified Date: 07 Jun 2023


How to show only 6 values up to a selected date by parameter.

Show 6 weeks of the selected parameter date.
User-added image


  • MS SQL Server


It is possible to follow along with the sample packaged workbook found in the Attachments section to the right of this article.

1. Create a parameter for the selected date as shown below:
User-added image

2. Create a calculated field of the selected date with the following values:
name: TS_selecteddate
value: IF [Order Date] <= [selected date] THEN TRUE END

3. Create a calculated field of the 6 values as described below:
name: TS_selected6
value: (LAST()+1) <= 6

4. Drag TS_selecteddate to the Filter card and choose True.

5. Drag TS_selected6 to the Filter card and choose True.
Did this article resolve the issue?