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

JLambs20's avatar
JLambs20
Helper III
4 years ago

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

Icey's avatar
Icey
Community Support
4 years ago

Hi JLambs20 ,

 

Do you mean to only show that both the start date and end date are within the selected date range? For example:

Is Task Visible =
VAR startDate =
    SELECTEDVALUE ( 'Table'[start date] )
VAR endDate =
    SELECTEDVALUE ( 'Table'[end date] )
RETURN
    IF (
        startDate >= MIN ( 'Date'[Date] ) -----------------changed
            && (
                ISBLANK ( endDate )
                    || endDate <= MAX ( 'Date'[Date] ) --------------changed
            ),
        1,
        0
    )

For more details, please check the attached .pbix file.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.