how to show dates between startdate and enddate in single slicer

[Anonymous]

hi all, I have a requirement where i have startdate and enddate of project in table1. now, i want to show display the dates between startdate and enddate in single slicer, so that i can filter projects come under those dates.. i tried by taking date and relating [date] from datetable to startdate in table1 and retreive the results...but in this case i'm missing based on enddate.. how can i sort this out..any solution ?? thanx in advance..

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a measure as below. Please note here there is no ralationship between tables.

Measure = 
VAR maxd =
    MAX ( 'CALENDAR'[Date] )
VAR mind =
    MIN ( 'CALENDAR'[Date] )
VAR edate =
    MAX ( 'Table'[End date] )
VAR sdate =
    MAX ( 'Table'[Start date] )
RETURN
    IF ( maxd >= edate && mind <= sdate, 1, BLANK () )

[Anonymous]

Hi v-frfei-msft,

     Thanx very much, that worked for the scenario i mentioned..

---