Date Diff Between Selected Ranges on Slicer

[Dhamu_114]

Hi,

I need to get the Number of days between the date ranges selected by user. Based on the number of days, Utilization will be calculated.

Date Slicer

Based on the selection, I managed to get the starting date and ending date. The calculation column used for these things are

For getting intial date.

For getting End Date.

But when i tried to get the date difference between these selected values, am facing issues. The date difference returns 0, Where I should get difference as 9 days.

The formula used for caluculating DateDiff is

THE OUTPUT I GOT IS

It will be great if someone help me in achieving this. Thanks In Advance.

[Zubair_Muhammad]

@Dhamu_114

What are the results if you simply use

=
DATEDIFF ( MIN ( 'table'[date] ), MAX ( 'table'[date] ), DAY )