Forum Discussion
Dynamic Date Filter
I have all of my visualzations based on a date range. I show a variety of measures based on the date, but want to limit the date to the range between the start and end date of a campaign. I have a sl...
May be add a calculate field on your calendar table called, "Within Campaign Date Range" and add filter on this field, check the syntax for following
WithinCampaignDateRange = if(Calendar[Date]>=Campaign[StartDate] && Calendar[Date]<=Campaign[EndDate], 1, 0)
Now on filter drop WithinCampignDateRange and put condition is 1
It will only show dates where value is 1. Just an idea.