Forum Discussion
Dhamu_114
8 years agoNew Member
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
- Zubair_MuhammadCommunity Champion
What are the results if you simply use
= DATEDIFF ( MIN ( 'table'[date] ), MAX ( 'table'[date] ), DAY )