Forum Discussion
Using Measure in DATESBETWEEN Function
My question is can I use a measure in the DATESBETWEEN dax function? Using TODAY() this works just fine I can slice by any date range. I would like to substitute a measure for TODAY(). The measur...
I'm not sure why, but DATESBETWEEN doesn't seem to work for me either.
However, you can use GENERATESERIES to return the period of desired dates based on the [Target Date] selected from the slicer.
NOTE: I used a range of the last 10 days (including today), but this is arbitrary. Use any range you like.
Perhaps someone else may know why DATESBETWEEN returns no records in this situation?
Hopefully GENERATESERIES works for you.
Regards,
Nathan