Forum Discussion

pistachio's avatar
pistachio
Helper I
7 years ago
Solved

Historical Overdue Days - Cumulative Pattern based on FIFO Transactions

I have a database of account transactions, each transaction has an overdue element (or blank) e.g. Date Account Element Value Overdue 31-Mar-19 Jack Pmt Due   250.00 1-Apr-19 Jack ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    try these:

    TOTAL OVERDUE = 
CALCULATE( 
    SUM( FactAccountTransaction[Overdue]),
        FILTER( DimDate, MAX(DimDate[Date]) >= DATEADD( DimDate[Date], -30, DAY ))
)

Total OverDue RT = 
IF(
    COUNTROWS(FactAccountTransaction) >=1,
    CALCULATE( 
        [TOTAL OVERDUE], 
        FILTER( 
            ALL( DimDate), 
            MAX( DimDate[Date]) >= DimDate[Date])
    )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Should be relatively easy, just not seeing how you are getting 150 for April first though. What would the value be on April 2nd and May 1st?