Forum Discussion

todebrownie's avatar
todebrownie
Regular Visitor
4 years ago

Inventory Projection

Hello Community, how are you?   I'm new to PowerBI and I'm trying to create a inventory projection. I would like to plot in a weekly basis (every monday) and would use some reports as starting poi...
Need Help
todebrownie's avatar
todebrownie
Regular Visitor
4 years ago

Hi V,

 

I've just sent you again.

 

Thank you!

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi todebrownie ，

 

Please try the following formula:

 

 

Shipments Acm = 
CALCULATE (
    SUM ( Shipments[Qty Invoiced] ),
    FILTER (
        ALL ( CalendarioM ),
        CalendarioM[WEEKNUM] < MAX ( CalendarioM[WEEKNUM] )
    )
)
Fcst Acm = 
CALCULATE (
    SUM ( Forecast[Value] ),
    FILTER (
        ALL ( CalendarioM ),
        CalendarioM[WEEKNUM] < MAX ( CalendarioM[WEEKNUM] )
    )
)
Measure = 
CALCULATE (
    FIRSTNONBLANKVALUE ( CalendarioM[WEEKNUM], [Initial Stock] ),
    ALLSELECTED ( CalendarioM[WEEKNUM] )
) - [Fcst Acm] + [Shipments Acm]

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.