DSO Dynamic for AR


Anyone has done a DSO ?

I have my dim_AR table and my fact_financial_moviment table
i need to have an DSO for each AR with dynamic ( ex: in Jan it was 15 days, in Feb, 45 in Mar its was 0)

Do we have an pattern for that?


I’m sure this is possible, but would have to see an example to really assist here.

I’ve looked up what DSO actually is because I wasn’t 100% familiar with it.

Based on this explanation though it will be possible, it just depends on the data setup mainly.