Forum Discussion

SandeA's avatar
SandeA
Helper III
4 years ago
Solved

Calculating DATEDIFF with a Specific Start date

I have an Invoice Average Lead Time KPI that is based on the Invoice Entered Date and the Payment date -

 
OBPdInv_InvLeadTime = DATEDIFF(OBPaidInvoices[Invoice_Entered_Date],OBPaidInvoices[Payment_Date],DAY)

 

The application where this data is initially entered had a bug in the Entered Date field and was just recently fixed. The data in the table goes back to 07/01/2021. We would like the KPI to show the average lead time to start with data entered on or after April 11, 2022. I don't really want to mess with the table if at all possible. Is there a way to modify my calculation above to show data entered on or after 4/11/2022?

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    SandeA , Try like

    OBPdInv_InvLeadTime = if(OBPaidInvoices[Invoice_Entered_Date] > date(2022,04,11) , DATEDIFF(OBPaidInvoices[Invoice_Entered_Date],OBPaidInvoices[Payment_Date],DAY) , blank())

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    SandeA , Try like

    OBPdInv_InvLeadTime = if(OBPaidInvoices[Invoice_Entered_Date] > date(2022,04,11) , DATEDIFF(OBPaidInvoices[Invoice_Entered_Date],OBPaidInvoices[Payment_Date],DAY) , blank())