https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3030588#M103546 <TABLE><TBODY><TR><TD><P>Qty Purchased</P></TD><TD><P>Sold qty</P></TD><TD><P>datephysical</P></TD></TR><TR><TD><P>100</P></TD><TD><P>10</P></TD><TD><P>01-01-2022</P></TD></TR><TR><TD><P>20</P></TD><TD><P>&nbsp;</P></TD><TD><P>11-01-2022</P></TD></TR><TR><TD><P>5</P></TD><TD><P>60</P></TD><TD><P>02-02-2022</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>7</P></TD><TD><P>03-03-2022</P></TD></TR><TR><TD><P>50</P></TD><TD><P>60</P></TD><TD><P>05-04-2022</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is sample dataset. We have to create the inventory aging report in the bucket of 0-15, 16-30, 31-45, 46-75, 75+ using FIFO method. How can we do that in power bi using DAX. Early reply is appreciated.</P> Thu, 19 Jan 2023 08:03:05 GMT rsingh 2023-01-19T08:03:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3030588#M103546 <TABLE><TBODY><TR><TD><P>Qty Purchased</P></TD><TD><P>Sold qty</P></TD><TD><P>datephysical</P></TD></TR><TR><TD><P>100</P></TD><TD><P>10</P></TD><TD><P>01-01-2022</P></TD></TR><TR><TD><P>20</P></TD><TD><P>&nbsp;</P></TD><TD><P>11-01-2022</P></TD></TR><TR><TD><P>5</P></TD><TD><P>60</P></TD><TD><P>02-02-2022</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>7</P></TD><TD><P>03-03-2022</P></TD></TR><TR><TD><P>50</P></TD><TD><P>60</P></TD><TD><P>05-04-2022</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is sample dataset. We have to create the inventory aging report in the bucket of 0-15, 16-30, 31-45, 46-75, 75+ using FIFO method. How can we do that in power bi using DAX. Early reply is appreciated.</P> Thu, 19 Jan 2023 08:03:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3030588#M103546 rsingh 2023-01-19T08:03:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3031677#M103620 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="368044" data-lia-user-login="rsingh" class="lia-mention lia-mention-user">rsingh</a> , refer if this old solution can help</P> <P><A href="https://community.powerbi.com/t5/Desktop/Inventory-aging-report/td-p/2492272" target="_blank">https://community.powerbi.com/t5/Desktop/Inventory-aging-report/td-p/2492272</A></P> Thu, 19 Jan 2023 15:06:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3031677#M103620 amitchandak 2023-01-19T15:06:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3040791#M104295 <P>Thanks for your response but I need to show the aging in aging buckets. Your early response is awaited.</P> Tue, 24 Jan 2023 15:52:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventory-Aging-Report-in-Power-BI/m-p/3040791#M104295 rsingh 2023-01-24T15:52:30Z