How to calculate a running total of available cars in fleet looking 14 days forward?

[NoobPowerUser]

I am trying to create a table view that will calculate the running empty cars available along with subtracting the target load daily for 14 day period starting Today based on Fleet, Sub Fleet and Origin catagory. I have the following dashboard built but the numbers are off.

Objective is to get the total of all empty cars for TODAY (first row) then based on the ETA calculate the sum of cars flagged as 'L' and 'E' for the remaining 13 out of 14 days. The Cars Available column should calculate starting next day fourmula as

Cars Available = Empty Cars (Previous Day) + Empty Car (current) - Car Loaded 

Car loaded will be static field (always)

EXAMPLE OUTPUT:

Current power bi dashboard I have tired to built.

Please ignore the Cars Ready column this is a test column which isnt working.

Measures of the Loaded Cars: 

Loaded Cars = IF(

    FIRSTDATE('Fleet Daily Status'[ETA])<=TODAY(),

    COUNTROWS(FILTER('Fleet Daily Status','Fleet Daily Status'[Load Empty]="L"&&'Fleet Daily Status'[ETA]<=TODAY())),

    COUNTROWS(FILTER('Fleet Daily Status','Fleet Daily Status'[Load Empty]="L"))

    )

Empty Cars = IF(

    FIRSTDATE('Fleet Daily Status'[ETA])<=TODAY(),

    COUNTROWS(FILTER('Fleet Daily Status','Fleet Daily Status'[Load Empty]="E"&&'Fleet Daily Status'[ETA]<=TODAY())),

    COUNTROWS(FILTER('Fleet Daily Status','Fleet Daily Status'[Load Empty]="E"))

    )

Cars Available= CALCULATE([Empty Cars] - 'Target Load Car'[Target Load Car Value],FILTER('14 Day Forecast',MAX('14 Day Forecast'[Date] )))

Data Fields

[NoobPowerUser]

Please see the linked file below with raw data and results under tab 'Output Results'. 

Fleet Data 

Goal is to measure how many days of car inventory are avaibale to load before running to zero. 

[v-binbinyu-msft]

Hi @NoobPowerUser ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu