Doubt regarding about calculating difference between dates

[Likhitha]

Hello All,

I'm having a status column and date column.I need to calculate datediff between preceding dates.How to do that?

[Ashish_Mathur]

Hi,

Try this calculated column formula

=[Date]-CALCULATE(MAX(Data[Date]),FILTER(Data,Data[Date]<EARLIER(Data[Date])))

Hope this helps.

[v-lid-msft]

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]

@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.

[amitchandak]

Try EARLIER

https://community.powerbi.com/t5/Desktop/Explanation-of-the-EARLIER-formula/td-p/529469

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601