Forum Discussion
Show items between start and end dates
You could swap the MIN('Date'[Date]) for MAX('Date'[Date]), that should do it
For the most part, this works pretty well, although I have discovered some limitations (to be fair, I didn't ask for this in the beginning). But let's say I want to see everything that is going on in February. If I have an entry that starts on Feb 10 and ends sometime in March, that entry will not be reflected in my visual since it doesn't occur in all of February. I'm not sure how to address that (or if it's even possible)?
You could swap the MIN('Date'[Date]) for MAX('Date'[Date]), that should do it
I think you may be on to something here. So far, it looks like it works but I'm going to QC it some more and if that's the case, I'll accept it as the solution! Thank you so much!
Hi John,
I was wondering if you could help me out with regards to an addition to this measure. Currently, the default chart shows all values regardless of blanks in the "start" or "end" column. To be clear, that is fine as I want the default to show those items that have blank start dates (I understand how absurd that sounds considering I'm showint a gantt chart). However, I'd like the chart to NOT show those items with blanks when a date in the date slicer is selected. As it sits, the chart will show all of the items that satisfy the date criteria but it's also still showing those with a blank start date. Thank you!