Forum Discussion
Date
Dear Community, I need to filter a Gantt Chart to show the list of ongoing projects between a specified period. However when i use the Slicer for the start and end date, it only uses the exact...
This works best with a disconnected Date table (or you need to remove the filter from the Date table if there is a relationship). You store the min and max dates from the Date table in variables and then COUNTROWS of your table where the EndDate is >= min date and the StartDate is <= max date.
Events in progress – DAX Patterns
Pat