Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
In DAX, the general measure pattern is as follows
Inventory :=
CALCULATE (SUM ( Inventory[StockCount] ),
LASTNONBLANK (Calendar[Date],CALCULATE ( SUM ( Inventory[StockCount] ) )))
this is pattern will work regardless of there being a count for every date (it will find the last count).
It will be possible but you will need to add a calculated measure to your cube. Are you using Tabular or Multidimensional? Both will work but one will use DAX while the other will need an MDX formula.