Forum Discussion

JLambs20's avatar
JLambs20
Helper III
4 years ago
Solved

Show items between start and end dates

Hello!   I have run into a recurring situation where individuals are asking to be able to use a filter to see all items in a table that "exist" between a start and end date, but the date they selec...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You could swap the MIN('Date'[Date]) for MAX('Date'[Date]), that should do it

johnt75's avatar
johnt75
Super User
4 years ago

You could swap the MIN('Date'[Date]) for MAX('Date'[Date]), that should do it

JLambs20's avatar
JLambs20
Helper III
4 years ago

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!