Inventory Aging Report in Power BI

[rsingh]

Qty Purchased	Sold qty	datephysical
100	10	01-01-2022
20		11-01-2022
5	60	02-02-2022
	7	03-03-2022
50	60	05-04-2022

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.

[amitchandak]

@rsingh , refer if this old solution can help

https://community.powerbi.com/t5/Desktop/Inventory-aging-report/td-p/2492272

[rsingh]

Thanks for your response but I need to show the aging in aging buckets. Your early response is awaited.