Hey,
once again I need your help. For some of my calculations it is mandatory to get the first and the last date, filtered by the slicer type "timeline".
This works well as long as the date is not used on rows or columns ...
As soon as I'm using theDate within the rows this very simplistic dax measure doesn't work ...
Of course I'm aware that suddenly the beast "Filter Context" shows its face again :-)
I'm wondering how to determine the StartDate (from the timeline) and the EndDate (from the timeline) when "thedate" is actively contributing to the filtercontext.
In my opinion it is not another example of the "event in progress" situation, due to the fact that start and end dates are actively selected by the user and can not be derived from within the date model.
But maybe I'm just stuck again, so any hint is very much aprreciated
My little Excel file can be found here ...
https://onedrive.live.com/redir?resid=2B60311E30171113!2526&authkey=!ABZDOgGNVJR6His&ithint=file%2cxlsx
Tom