Power Bi Expert Needed: Finish Inventory, Expiry & Consignment Stock Dashboard (Dax + Report Design)

I need an experienced Power BI developer to finish a Power BI Desktop report for a medical supplies distributor. The report tracks consignment stock across 4 hospitals, with about 50 products and several lots per product. The data model and Power Query layer are already built, so the remaining work is mostly DAX, report design and validation.Background: Source: a daily Excel export from SAP with one row per lot. It includes stock, 30/90-day consumption, last consumption date, expiry date, status, unit price and backorders. Master tables for Products, Hospitals and Returns are included. Already done: the Power Query split into fStock (lot grain) and fSituacion (product × hospital grain), plus the dimensions (dProducto, dHospital, dEstado, dCalendario), relationships in a star schema, and a parameter for the low-rotation threshold. The sample dataset and the M code are included. Report language: Spanish. All names, titles and labels must be in Spanish. Communication with me is in English.What you'll do: 1. Model finishing: sort columns, hide technical fields, and set € formats and thousands separators. 2. Dax calculated columns: days to expiry, fefo logic (stock from earlier-expiring lots, then stock at risk and value at risk, limited to a 365-day horizon), risk level and expiry bucket. I will provide the logic and draft formulas. 3. About 35 DAX measures grouped in display folders: Stock, Valuation, Expiries, Risk, Material Status (Active / Low rotation / Obsolete), Returns (month-over-month change, last 12 months, % of total). Backorders must not be double-counted across lots. 4. What-if parameter for the expiry window (30/60/90+ days). 5. Custom JSON theme with clear colours for risk and status.Deliverables: The final .pbix file, DAX code in .dax or text files, The theme JSON, The measure documentation.