Forum Discussion
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[Paymen...
SandeA , Try like
OBPdInv_InvLeadTime = if(OBPaidInvoices[Invoice_Entered_Date] > date(2022,04,11) , DATEDIFF(OBPaidInvoices[Invoice_Entered_Date],OBPaidInvoices[Payment_Date],DAY) , blank())
SandeA , Try like
OBPdInv_InvLeadTime = if(OBPaidInvoices[Invoice_Entered_Date] > date(2022,04,11) , DATEDIFF(OBPaidInvoices[Invoice_Entered_Date],OBPaidInvoices[Payment_Date],DAY) , blank())