I am just trying to formulate for monthly count of the customers which paid over the period.
I was able to formulate for the one with full payments. however if they paid partially over the period, our ERP produce the record of payment date and amount in different lines. in my Power query or excel calculation, I have duplicated records as attached.
Please guide me to get the power query formula corrected.
Solution_MOTH_RADCal_-1.xlsx (34.9 KB)