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!
