Forum Discussion

JoaoMS's avatar
JoaoMS
Icon for Helper III rankHelper III
6 years ago
Solved

Look for a date in a Column List

Hi all, I need your help with the following issue. In our company we have a list of fixed dates for paying suppliers (two dates each month, usually the 1st and 15th day of each month). These dates ar...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    In the invoice table write this calculated column formula

    =CALCUATE(MIN(PaymentTable[Fixed_Dates]),FILTER(PaymentTable,PaymentTable[Fixed_Dates]>EARLIER(InvoiceTable[Invoice_Dates])))

    Hope this helps.

JoaoMS's avatar
JoaoMS
Icon for Helper III rankHelper III
6 years ago

Dear all, i'm very sorry for my delay in answering your comments, unfortunately I'm already have this problem. I'm attaching a picture with the two (2) tables which have the main information. The "InvoiceTable" will always have new data, while the "PaymentTable" has fixed dates for the payment days. We expect to have the "Output" table relating the information of the "InvoiceTable" with the day of payment. 

 

 

Regards,

Joao

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

You need a  column in the Payment table to merge against. Perhaps the Invoice number?

 

Please provide sample data, not screenshots. Paste the data in a table, or link to an Excel file via OneDrive so we don't have to rekey. Screenshots are nice to see expected output, but then you are expecting someone to rekey that info in to do the work.