Forum Discussion
Dynamically Filter a Calendar Table based on Start & End Date from Slicer
I am trying to use the 'MonthNameLong' and 'Year' from a disconnected table but I don't know the best practice and/ or simplest way. The end user will select both to act as the end date, and another ...
shubuya - Since you are considering values from previous years, you don't want to use a YTD calculation. You're looking for something more like:
Departures Running Total =
var displaydate = MAX('Calendar'[Date])
return
CALCULATE(
<Count Measure (Not YTD)>,
'Calendar'[Date] <= displaydate
)
Thanks for your help - I think I am close, but when I use the formula you provided the chart is not scaling to show the dates 1/1/2015 to 12/31/2015. How do I edit your formula to only show that date interval?
shubuya - The Year and Month for the Slicers and for the Line chart all need to come from the Date table.