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 ev...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sample data is already there in the screenshot.

I assume this should be sufficient for defining the DAX statememt.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Okay, I do not understand your request.
    Hopefully you find someone who does it.

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    6 years ago

    Hey Anonymous ,

     

    I guess this will become quite difficult because neither DAX nor M will persist data, meaning whenever data will be refreshed, the DAX (calculated column) or the M script will evaluate the script for the same row once again.

     

    So, assuming there is due date 2019-12-12, and data will be refreshed on the 12th, this row should be considered for clearance on the 12th?

    What will happen, if the data will be refreshed on the 15th, the same row will be considered for clearance on the 15th, as it seems your data model does not contain any information about "runs".

     

    I guess as mwegener was asking for sample data, was the question for providing reusable sample data, as a screenshot is not reusable in an easy way.

    Please consider to provide a pbix and or xlsx file(s), that contain sample data and represent your data model. Upload the file(s) to onedrive or dropbox and share the link.

     

    Regards,

    Tom

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago

      I thought it's clear that Power BI can only query data but can not persist data.

      So the information about the payment run etc. must be present in the data source.

       

      I asked for sample data to understand what the input data is and what the result should be.