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 one assist me on this dax?
2 Replies
BrianConnellyResolver III
With 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
)