Forum Discussion

IAM's avatar
IAM
Helper III
3 years ago

Available stock in future

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! 
 
 
Need Help

1 Reply

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable Member
    3 years ago

    Hello IAM 

     

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

    Regards,

    Naveen