Date slicer - duration

Considering the slicer is created on Date[Date]

Date Harvest Min = CALCULATE( MIN( Dates[Date] ), ALLSELECTED( Dates[Date] ) )
Date Harvest Max = CALCULATE( MAX( Dates[Date] ), ALLSELECTED( Dates[Date] ) )
Date Difference = DATEDIFF( [Date Harvest Min], [Date Harvest Max], DAY )

Hi Anonymous ,

Similar to the formula given by arvindsingh802 , refer to the following test results.

M_ = 
var min_date = MIN('Table'[Date])
var max_date = MAX('Table'[Date])
return DATEDIFF(min_date,max_date,DAY)

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.