Power BI Stock Aging Dashboard

I need a straightforward yet reliable Power BI dashboard that lets me pick any “as-of” date and immediately see how long each item batch has been sitting in stock. The core of the work is shaping one item-ledger table (item number, batch, transaction date, transaction type) so that it dynamically produces:

• Inventory on hand as of the selected date.
• Monthly aging buckets showing days held for every item/batch.
• Transaction categories grouped exactly as “Inbound, Outbound, Internal.”
• Quick slicers for Item Number, Batch Number, and Transaction Type.

A clean Power Query (M) model, concise DAX measures, and a single PBIX file are all I need for this initial concept—no fancy visuals beyond standard tables, matrices, and a simple bar chart for the aging buckets. Accuracy through any chosen cutoff date is essential, and the solution must work without hard-coding balances so I can reuse it each month.

If you’re comfortable building compact, well-documented queries and measures that match the points above, I’d love to review your approach and get this first version running quickly.