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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Share both datasets and for a few rows show the expected result.