https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-with-DAX/m-p/3051499#M105117 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="506717" data-lia-user-login="AS2204" class="lia-mention lia-mention-user">AS2204</a> , check if this logic can help </P> <P><A href="https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model" target="_blank">https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model</A></P> <P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Calculate-Inventory-Days-Using-DAX/m-p/1879983" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Calculate-Inventory-Days-Using-DAX/m-p/1879983</A></P> <P><A href="https://blog.enterprisedna.co/calculate-days-of-zero-stock-power-bi-inventory-management-insights/" target="_blank">https://blog.enterprisedna.co/calculate-days-of-zero-stock-power-bi-inventory-management-insights/</A></P> Tue, 31 Jan 2023 02:04:36 GMT amitchandak 2023-01-31T02:04:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-with-DAX/m-p/3050691#M105066 <P>Hi guys, i urgently need help with this task.</P><P>I have my stock amount for the last day of the selected period. And the Plan stock amount for the months after the last day of the selected period.&nbsp;</P><P>&nbsp;</P><P>For example, the balance on January 31 is 100 pieces of something, and the plan</P><P>February 70<BR />March 10<BR />April 40</P><P>Stock is enough for 2.5 months (first February - enough for the whole month, March - for the whole month, April for half a month 1+1+0,5 ).</P><P>What dax formula should I use in this case to get ''2.5 months'' number? Only one number like this is required as a solution for this task, many thanks..</P> Mon, 30 Jan 2023 15:04:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-with-DAX/m-p/3050691#M105066 AS2204 2023-01-30T15:04:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-with-DAX/m-p/3051499#M105117 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="506717" data-lia-user-login="AS2204" class="lia-mention lia-mention-user">AS2204</a> , check if this logic can help </P> <P><A href="https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model" target="_blank">https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model</A></P> <P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Calculate-Inventory-Days-Using-DAX/m-p/1879983" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Calculate-Inventory-Days-Using-DAX/m-p/1879983</A></P> <P><A href="https://blog.enterprisedna.co/calculate-days-of-zero-stock-power-bi-inventory-management-insights/" target="_blank">https://blog.enterprisedna.co/calculate-days-of-zero-stock-power-bi-inventory-management-insights/</A></P> Tue, 31 Jan 2023 02:04:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-with-DAX/m-p/3051499#M105117 amitchandak 2023-01-31T02:04:36Z