Calculating DATEDIFF with a Specific Start date

[SandeA]

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?

[amitchandak · Accepted solution]

@SandeA , Try like

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