topic Re: Difference between dates in the same column in Developer

Difference between dates in the same column

Samuelcurr1e — Sun, 04 Sep 2016 06:20:14 GMT

Hi,

I have a financial approvals table that has the action date in the same column, I am trying to find out the lenght of time each the process is at each stage of the process. The table below is an exmpale of what I am working with. Any help would be greatly appreciated.

Re: Difference between dates in the same column

v-chuncz-msft — Mon, 05 Sep 2016 06:37:32 GMT

Samuelcurr1e,

According to your description, you could add a calculated column as follows.

Duration Column = 
DATEDIFF (
    Table1[Action Date],
    LOOKUPVALUE (
        Table1[Action Date],
        Table1[Req No], Table1[Req No],
        Table1[Apr Seq No], Table1[Apr Seq No] + 1
    ),
    HOUR
)

Re: Difference between dates in the same column

Samuelcurr1e — Mon, 05 Sep 2016 06:52:57 GMT

Hi Sam,

Thanks for your response. I seem to get an error when using the calculation, 'Calculation error I column 'PR Process'[]: In DATE DIFF function, the start date cannot be greater than the end date' I've not seen this error before, any ideas?

Cheers

Sam

Re: Difference between dates in the same column

v-chuncz-msft — Tue, 06 Sep 2016 10:34:18 GMT

Samuelcurr1e,

For DATEDIFF Function, an error is returned if start_date is larger than end_date. To quickly resolve the issue, you may need to provide more information.