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