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
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