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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Model setup
Measures
Sales In Qty =
SUM('Sales In'[Qty])
Sales Out Qty =
SUM('Sales Out'[Qty])
Net Movement =
[Sales In Qty] + [Sales Out Qty] * COS(PI())
Initial Stock Qty =
COALESCE(SUM('Initial Stock'[Qty]), 0)
Cumulative Net Movement since 2020 01 01 =
VAR Anchor = DATE(2020, 1, 1)
RETURN
CALCULATE(
[Net Movement],
FILTER(
ALLSELECTED('Date'[Date]),
'Date'[Date] >= Anchor && 'Date'[Date] <= MAX('Date'[Date])
)
)
Stock On Hand by date =
[Initial Stock Qty] + [Cumulative Net Movement since 2020 01 01]
Stock at month end for visuals grouped by month =
VAR LastDay = EOMONTH(MAX('Date'[Date]), 0)
RETURN
CALCULATE(
[Stock On Hand by date],
KEEPFILTERS('Date'[Date] = LastDay)
)