Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Query Condition Help

    Posted Nov 26, 2021 05:25 AM
    Hi,
    I have two tables one is Alternate_Prod_Id and another is Final Qty, I want to update qty based on the stock availability, In this situation for 3 products there is only one alternate whose stock is 27 only and the demand is of 4+15+10+14=43. So, it should split based on the coverage and Demand. Please help me writing the condition for this situation.



    Alternate_Prod_Id


    Table 2:

    Final result may look like this:

    or it can distribute the qty based on the Demand.


    ------------------------------
    J M
    ------------------------------