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
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi todebrownie ,

 

Has your problem been solved? 

 

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

todebrownie's avatar
todebrownie
Regular Visitor
4 years ago

Hi,

 

I sent you a private msg with my data. Could you please take a look?

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

    Hi todebrownie ,

     

    I'm very sorry, I didn't read the private message before. I clicked on the link you shared, but it indicated that the link had expired. Could you please share it again?

     

     

    Best Regards,
    Winniz

    • 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.