The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)
Solved! Go to 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.
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.
@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() ) )
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |