Date Filter using Calculated field

Hi @murili

I found the following case as an answer to my question.

I did the following:

Created a Parameter Reporting Week and added that to the Control
image

Created two calculated fields From and To Date to derive my date range
image

image

Created an additional Calculated field which looks at the dataset field and the date range and returns a boolean 1 or 0 as a way to enable me to use that as a Filter for the visual

image

Used the Date in Range calculated field to Filter the visual.

1 Like