Forum Discussion

Dhamu_114's avatar
Dhamu_114
New Member
8 years ago

Date Diff Between Selected Ranges on Slicer

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.

1 Reply