Skip to main content
DD-INV-002 Retail and Manufacturing: Transfers, Counts and Stock Nobody Ordered — Inventory & Stock Get the data →
DD-INV-002-Q003 Easy Time series

Raw materials today

Append FactStockMovementsLatest to FactStockMovements first. Stock at a date = the sum of Value (or Quantity) of the movements with MovementDate on or before it. What was the value of raw materials at both plants on 30 September 2026, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactStockMovements, FactStockMovementsLatest, DimItem · columns
  • FactStockMovements
  • FactStockMovementsLatest
  • DimItem
  • MovementType
  • MovementDate
  • Quantity
  • Value
  • LocationCode
  • ItemType

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in