Forum Discussion
Date range dynamicaly
I have 3 months data. Want monthly MTD dynamicly for current month. I want to put start date of available latest month ( obviously 1day) and Available last date in date range selection . Any on...
BrianConnelly
Resolver III
Resolver IIIWith the limited example and data provided, I think what you are saying is that there is a filter for the last date?
If so,
Measure Name =
Var StartDate = DATE(YEAR(TODAY()), MONTH(TODAY()),1)
Var EndDate = SELECTEDVALUE( [Assumed Date Table with a Date Field], Default Value (You can use TODAY() )
RETURN CALCULATE( SUM(of some field), FILTER(ALL(some date field),DATESBETWEEN (some date field,StartDate,EndDate
)