Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    mwegener
    Icon for Most Valuable Professional rankMost 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I want to implement above requirement through DAX.

      Payment System is as defined above by client.

       

       

      • mwegener's avatar
        mwegener
        Icon for Most Valuable Professional rankMost 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.