Skip to main content
DD-ECL-002-Q011 Easy

Credit-impaired customers on the books

Append FactOpenItemsLatest to FactOpenItems first. How many customers have open items at the latest month end in the data (30 September 2026) and a CreditImpairedDate on or before it?
Expected
One whole number · KPI card
Tables
FactOpenItems, FactOpenItemsLatest, DimCustomer · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • DimCustomer
  • CustomerCode
  • CreditImpairedDate
  • SnapshotDate

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