Forum Discussion

mcolb88's avatar
mcolb88
Helper III
9 years ago

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...
Need Help
parry2k's avatar
parry2k
Super User
9 years ago

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.

  • mcolb88's avatar
    mcolb88
    Helper III
    9 years ago

    Funny, had that thought too...

     

    DateInCampaign =IF([Call Date] >= [Campaign Start Date] && [Call Date] <= [Campaign End Date], TRUE(), FALSE())

     

    [Campaign Start Date] and [Campaign End Date] are measures calauclated as the min() and Max() of thoise dates in the scenario where mutliple campaigns are selected.

     

    So I drop a table on a report showing the Call Date and DateInCampaign.

    When I select a campaign, in the slicer, these Campaign Start and End change, but the values for DateInCampaign do not :(

     

    Thanks for the idea, this should work though right? Or are the calculated columns re-calculated at process time?