Forum Discussion

geraldb's avatar
geraldb
New Member
6 years ago

Create a Dynamic Flag based off a Date Range Slicer

Hello;   I have a data set of projects that have both a start and a finish date, for example:   Project Number Project Name Start Date Finish Date 1 Abc 1/15/2020 4/21/2020 2 Def ...
date range
Dax Help
Dynamic Flag
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi geraldb ,

 

This should do the "trick".

 

Flag = calculate( COUNTROWS(Projects), filter(Projects, Projects[Start Date]<Max('date'[Date]) && Projects[Finish Date]>Min('date'[Date])))

Jan 

  • geraldb's avatar
    geraldb
    New Member
    6 years ago

    Jan;

     

    Thanks for your help with this!  I am still running into an error, however.  When I create the measure I get an error saying, "Cannot find table 'date'."  From your screenshots it looks like this should be the slicer, but the meausre doesn't seem to recognize it, how do i identify the slicer in a way that the measure can read it?

     

    Thanks

     

    Gerry

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Gerald,

       

      I assumed that you have a "date" table in you model. Typically it would be the same field that you use in your "Active Date Range" slicer.  So if you table/field is called 'Dates'[Active Date Range] then you need to substitute 'date[Date]' with 'Dates'[Active Date Range]. 

       

      Hope this helps, otherwise a bit more information is required. 

       

      Jan