Forum Discussion
Show Tasks in specific month using date slicer
- 6 years ago
Hi, Haya
Based on your description, I created data to reproduce your scenario.
You may create a Date table as follows.
Calendar = CALENDARAUTO()Then you can create a measure as below.
IsProcess = var _mindaterange = CALCULATE( MIN('Calendar'[DateRange]), FILTERS('Calendar'[DateRange]) ) var _maxdaterange = CALCULATE( MAX('Calendar'[DateRange]), FILTERS('Calendar'[DateRange]) ) return IF( NOT OR(_maxdaterange<MAX('Table'[Start Date]),_mindaterange>MAX('Table'[End Date])), 1,0 )Finally you need to put the measure to the visual level filter. Here are the results.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Haya
There is a many-to-many relationship betwwen 'id' and 'Assigned to'. So for 'Employee 24' it exsits both situations when the conditions are met and situations when the conditions are not met. The result will be 2.
You may try to add 'Id' to 'Rows' in 'Fields' ribbon. Here is the result.
Best Regards
Allan
I put "title" instead of "Id" to present more meaningful data as follows,
Thanks v-alq-msft for your continoues help !