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...
My apologies for the screenshots still referring to TODAY().
It's the same solution.
You just replace it with the dynamic measure and it works, as long as you're using GENERATESERIES.
NOTE: I only added the CountRowsInPeriod VAR so that it would return a scalar value for testing. If you're returning the table, then you'll need to use it in another way (e.g. as a filter argument or something).
Regards,
Nathan