topic Historical late payment with DAX in DAX Commands and Tips

Historical late payment with DAX

Anonymous — Sat, 28 Jan 2023 02:13:51 GMT

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)

amitchandak — Sat, 28 Jan 2023 02:21:33 GMT

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 — Sat, 28 Jan 2023 02:34:23 GMT

Not working 😞

v-jianboli-msft — Mon, 30 Jan 2023 05:21:54 GMT

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.