Available stock in future

[IAM]

Hi all,

Can anyone tell me if the following is possible?

I have a table with the planned material in rent:

BridgeTable[Datum] with the date of rental

BridgeTable[SerialID] has the serial number

I have a DimEquipment table

DimEquipment[SerialID] has the serial number

DimEquipment[Aantal] has the amount of available items (1 per serialID)

Every day I have the amount of DimEquipment[Aantal] again. Now I want to calculate how much I have available on a day. 

Because I don't have a date connected to my DimEquipment table I can't use a measure to 

CALCULATE([Total Available Stock]) - CALCULATE([Total Rented Equipment])

Total Available Stock = SUM(DimEquipment[Aantal])

Total Rented Equipment = COUNT(BridgeTable[SerialID])

Is there a way to force using the [Total Available Stock] again for each date?

Any help is very much appreciated! 

[NaveenGandhi]

Hello @IAM 

Can you share sample data/PBI file and desired output to understand the problem better?

Regards,

Naveen