Forum Discussion
Variable End dates for DATESBETWEEN function
Hi Everyone, this is the first question will throw in here. Been searching through various forums of similar issue but could not found anything online so here it goes. I am trying to have Calend...
Jsevilleja , Hope that is selected value
example
= TODAY()+ SelectedValue('Calendar Week Look Ahead'[Week Variable])
and this used in a measure, if you use that in column or table , it will not take slicer value
DATESBETWEEN('Calendar'[Date],TODAY(),'Calendar'[1 Week])
example
CALCULATE([ViewsCount], DATESBETWEEN(Dates[Date],StartDate,MidDate))