Calculated column showing number of overlapping dates with same material #

[Anonymous]

Im trying to write Dax formula that gives the number of overlapping time periods for that row with the other rows with the same material #

[PaulOlding · Accepted solution]

Hi @Anonymous 

You have one line on your data where the end date is before the start date.  I've assumed that's a typo in this solution.  If that is something that can occur the CALENDAR function will cause an error

Overlaps = 
VAR _calendar = CALENDAR('Table'[start date], 'Table'[end date])
VAR _material = 'Table'[Material #]
RETURN
COUNTROWS(
    FILTER('Table', 
        'Table'[Material #] = _material
        && COUNTROWS(INTERSECT(CALENDAR('Table'[start date], 'Table'[end date]), _calendar)) > 0
        )
    ) - 1

[Anonymous]

can you modify this so it return the maxium over lap by day over the time interval. 

i want the column to show the most number by row material number it over laps with on a single day. Not the whole start to end date.