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
Please see the attached file with a solution + a video step by step.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks Mariusz
I followed your steps, however I couldn't make relation between Table and Table (Referenced). this error appears
Also I have some due dates that are empty so I couldn't appy ... operator
- Mariusz6 years ago
Community Champion
Hi Haya
You can add an index column to your "Table" table to make the records unique and later use Index columns to create relationship.
In reference to blanks due to null dates, you can replace them with today's date, for example, I've made the adjustment to the code in the attached file to accommodate null scenario.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn- Haya6 years ago
Helper II
Thanks Mariusz
The problem of your approach that it duplicates the tasks when I extract the Date to new rows.
It affects the whole Data, so when I count for example number of tasks for each employee it returns incorrect data.
- amitchandak6 years ago
Super User
Haya ,
I am not completely on the issue. But these two file address a similar issue. Have a look
https://www.dropbox.com/s/5wo5jhzl488zy69/Minute_between%20Hours.pbix?dl=0