SELECTEDVALUE which selects two dates and feed into a DAX formula

[divyaaggarwalbA]

Hi All,

Hope you can help.

I am trying to use end user input values to feed into a DAX formula. For this I am using two different date tables.
End Date 
Start Date

the Formula for DAX for selecting single value from each table is 

End Date = DATEVALUE(FORMAT(SELECTEDVALUE('End Date'[Date],0),"dd/mm/yyyy"))

Start Date = DATEVALUE(FORMAT(SELECTEDVALUE('Start Date'[Date],0),"dd/mm/yyyy"))

these two formula give me the expected result. But when i try to feed these two formulas into Calculated columns it is not working. The calculated column is basically tring to check if the column [P_date](Date type) in table 'A table' lies in Start and end date range.

Column =

if(AND('A table'[P_date]>= 'Start Date'[Start Date],'A table'[P_date]<= 'End Date'[End Date]),1,0)
the answer is always 0 even when the P_date is in Start an end date range.

Thanks

[mlsx4]

Hi @divyaaggarwalbA 

If you want to check that the date is between two values, you should relate them with calendar table (without any active relationship) and use something like:

Start Date'[Start Date]<=MAX('A table'[P_date]) && 'End Date'[End Date]>=MAX('A table'[P_date])

[divyaaggarwalbA · Accepted solution]

@mlsx4 yes found th solution with sth similar posting for future visitors. I created a measure instead.

Measure =

 if(MAX('A table'[P_date])>= 'Start Date'[Start Date] && Max('A table'[P_date])<= 'End Date'[End Date],"your required result",BLANK())