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.

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.