Forum Discussion

Likhitha's avatar
Likhitha
Helper IV
6 years ago

Doubt regarding about calculating difference between dates

Hello All, I'm having a status column and date column.I need to calculate datediff between preceding dates.How to do that?
Need Help
Show and Tell
Tips and Tricks
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Likhitha ,

 

We can create a calculated table to meet your requirement:

 

Column =
DATEDIFF (
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Table', 'Table'[Date] < EARLIER ( 'Table'[Date] ) )
    ),
    [Date],
    DAY
)

 

 


If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.


Best regards,

 

  • Likhitha's avatar
    Likhitha
    Helper IV
    6 years ago

    v-lid-msft  

    I have one date column from which i need to calculate the net working dates with time duration.

    What i have did is created a calendar table from which i calculated the sum of weekdays am achieving the networking days, but not the time included.

    Can anyone help me how i can achieve networking days along with the time?

    Screenshot of the raw data and the logic.