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.

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi JoaoMS,

use something like this for you calculated column:

pd =
CALCULATE (
    MIN ( paymentDates[paymentDate] );
    FILTER ( paymentDates; paymentDates > invoice[invoiceDate] )
)

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.