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.