Inventory Forecast Future

Hi Anonymous 

 

It seems like you're trying to create a forecast that takes into account the rolling average of the last 14 days to project future inventory levels. 

 

The circular dependency error you're encountering typically occurs when a calculation refers back to itself directly or indirectly, creating a loop that Power BI cannot resolve.

 

The following ways may solve your problem:

 

First, ensure you have a measure that accurately calculates the rolling average of the last 14 days. 

 

 

To calculate the ending stock for each day, you can create a measure that takes the previous day's ending stock and adjusts it based on the orders and the rolling average usage. However, to avoid circular dependency, ensure that each calculation is based on previously calculated or static values.

 

ENDING STOCK = 
    CALCULATE(
        SUM('Table'[ON HAND FORECAST]) + SUM('Table'[ORDER QTY]) - SUM('Table'[USAGE FORECAST]), 
        FILTER(
            ALL('Table'), 
            'Table'[DATE] = MAX('Table'[DATE])
        )
    )

 

Here is the result.

 

 

If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.