Forum Discussion
finding Date Difference grouped
Hello there, My sample data is desired output is : i could achieve the earliest start and latest end. But couldn't achieve Date difference is as 6 . the measure i tried takes...
HI
Earliest_Start=calculate(min(Start Time), all(tablewithdata))
Lastest_End= calculate(max(Start Time), all(tablewithdata))
Days=[Lastest_End]-[Earliest_Start]
Thank you JamesFR06
This method, i have already tried. it will take difference of Jan 04 to Dec 29 - which is 360 days
the expected output is 04/01 to 06/01 + 29/12 to 31/12 , which is 6 days in total
the second row difference should be skipped, because it is already covered in (29/12 to 31/12)
the 3rd , 4th , 5th rows difference should be skipped, because it is already covered in (04/01 to 06/01)
instead of taking all dates, it should cover the existing from , to date difference only.
Please guide