https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-calculation-of-product-purchase-value/m-p/4134039#M164204 <P>Hello, I need to do the same. Have you been able to achieve it yet? Thank you</P> Wed, 04 Sep 2024 18:58:39 GMT MMPagola 2024-09-04T18:58:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-calculation-of-product-purchase-value/m-p/3415801#M157589 <P>Good morning friends, I was currently asked to create inventory kardex for the company, it should be noted that it is a single product.<BR />From it I have records of entry, exit, purchase costs, accumulated inventory after each movement.</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwinmoreno1799_1-1693921346387.png" style="width: 400px;"><img /></SPAN></P><P>The value that says tickets is the multiplication of the quantity purchased by the purchase value. <BR />.- Now I would need to calculate the balance of the inventory initially would be 5819.35 but when they begin to register movements must be calculated, serious = previous inventory balance + purchases - production - salesbox (I leave print of an excel that was created to have a guide)</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwinmoreno1799_2-1693921634354.png" style="width: 400px;"><img /></SPAN></P><P>- Now I need to calculate the weighted average that would be Inventory balance / quantity in inventory (in excel it is called balance)</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwinmoreno1799_3-1693922147784.png" style="width: 400px;"><img /></SPAN></P><P>- Finally I would need to calculate the value of the outputs of products, whether to production or cash sales. multiplying the output quantity by the last weighted average value.</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwinmoreno1799_4-1693922282246.png" style="width: 400px;"><img /></SPAN></P><P>I hope to explain myself well. Thanks in advance</P><P><BR /><BR /><BR /></P> Tue, 05 Sep 2023 14:00:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-calculation-of-product-purchase-value/m-p/3415801#M157589 Syndicate_Admin 2023-09-05T14:00:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-calculation-of-product-purchase-value/m-p/4134039#M164204 <P>Hello, I need to do the same. Have you been able to achieve it yet? Thank you</P> Wed, 04 Sep 2024 18:58:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-calculation-of-product-purchase-value/m-p/4134039#M164204 MMPagola 2024-09-04T18:58:39Z