Forum Discussion
jamiefisher
Helper I
Helper IUsing a date parameter / filter in a visual
I have a table of absences e.g Name Start Date End Date John 01/08/23 30/08/23 John 10/03/23 11/03/23 Mark 02/08/23 04/08/23 I want users to be able to select a date e....
Hi,
If you are going to use a single value for your date selection you could use something like this:
Measure =IF (SELECTEDVALUE('date'[Date]) >= CALCULATE(MAX('Table'[Start Date]))&&SELECTEDVALUE('date'[Date]) <= CALCULATE(MAX('Table'[End Date])),"Yes","No")you'll need a separate date table, i've included a PBIX file to reviewIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
DOLEARY85
Resident Rockstar
Resident RockstarHi,
If you are going to use a single value for your date selection you could use something like this:
Measure =
IF (
SELECTEDVALUE('date'[Date]) >= CALCULATE(MAX('Table'[Start Date]))&&
SELECTEDVALUE('date'[Date]) <= CALCULATE(MAX('Table'[End Date])),
"Yes",
"No"
)
you'll need a separate date table, i've included a PBIX file to review
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍