Skip to main content
DD-INV-001 Mizan Retail: Shelves, Stock and Ramadan — Inventory & Stock Get the data →
DD-INV-001-Q030 Very Hard Time series

The month stock sat longest

Monthly DIO = ClosingValue at the month-end / IssuedValue of that month x the days in the month. Over all the month-ends from January 2024 to September 2026, which had the highest DIO? Give it as yyyymm.
Expected
One month as yyyymm · Line chart of monthly DIO
Tables
FactStockSummary, DimDate · columns
  • FactStockSummary
  • DimDate
  • ClosingValue
  • IssuedValue
  • PeriodKey

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