Date Diff calc from one field current cell to previous field cell

[Sandeep_PowerBI]

Hi Team,

Good Day!

I need to calculate the Running time of vehicle for 2 date fields (Notify Date & Complete Date). Below is the reference screenshot. I have to show same for all the vehicles in individual months (Jan 31 days; Feb 28 days; Mar 31 days; Apr 30 days etc.,)

Eg: Each monthb (Jan - Start: 01/01/2023 12:00 AM to End: 31/02/2023 11:59 PM), Need to calc running days for each month.

This is Actual table available:

Need O/p:

Calculated in Excel; How to do it same in Power BI?

Kindly help with the DAX command to calc the Running time?

Thank you!

Regards,

Sandeep

[Mahesh0016]

@Sandeep_PowerBI 

Sales Amount = SUM(Table[Running Time(Days)])
****************************************

Sales RT :=

VAR MaxDate = MAX ( 'Date'[Date] ) 

RETURN

    CALCULATE (

        [Sales Amount],           

        'Date'[Date] <= MaxDate,  

        ALL ( Date )    ,
         ALLEXCEPTE(Table,Table[Car No])

    )

THANK YOU!!