Forum Discussion
DAX Payment Run logic
As per the client's account payable process, payment for all the due invoices are done as per the following payment cycle:
10th of every month
15th of every month
20th of every month
end of every month
For example :
If a invoice has due date of 2nd of month then it will be paid on 10th of that month and if a invoice has due date 12th of month then it will be paid on 15th of that month.
Requirement :
Now, client has requirement that suppose a invoice if due on 15th of this month and I run a payment run today (out of regular payment cycle) i.e. 08-12-2019 and clear(pay) that invoice (ideally, it should be cleared in 15th payment cycle) then clearing date should be updated as of today and it should not be considered in 15th payment run cycle (Maybe, we flag this as already paid and corresponding payment date).
Please let me know how this can be thrugh DAX.
7 Replies
- mwegener
Most Valuable Professional
Hi Anonymous,
what are the requirements for Power BI?
The existing requirements relate to the payment system or not?
Please give Kudos for support.
- AnonymousNot applicable
I want to implement above requirement through DAX.
Payment System is as defined above by client.
- mwegener
Most Valuable Professional
Hi Anonymous ,
could you please provide some sample data, what your source data looks like and what your result should look like?
Please give Kudos for support.