Historical late payment with DAX

[Anonymous]

Hello, I have a table that contains the due date of a bill and the date of payment.

I need to count each day the number of bills late on the day (even it's paid nowdays). Any idea?

Eg: in 2022/07/11 ID 29040 was late (because the due date is 2022/07/10 and the payment occured on 2022/07/12)

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

Please try:

Measure = SUMX('Table',IF([Payment Date]>=[Due Date],1,0))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , For any selected date ( prefer independent date table)

Late payments are

countrows(filter(Table, [Payment Date] > [Due date] && [Due Date] <= Max(Date[Date]) ) )

before today

countrows(filter(Table, [Payment Date] > [Due date] && [Due Date] <= today() ) )

[Anonymous]

Hello @amitchandak 

Not working 😞