I have the following formula in a power
I have the following formula in a power pivot measure:
CALCULATE(sum(GL20000[Amount]),datesbetween(GL20000[Transaction Date],date(2007,12,31),date(2011,3,31)))
It works exactly as I want, butI would like to replace date(2011,3,31) with what is selected on my Transaction Date slicer. Is this possible?