Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Average between dates

Hello! I am calculating the average between 2 dates (application start date and closing date). Create a column to calculate the duration with the following formula: Duration = DATEDIFF('Table'[St...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Assuming Duration is a calculated column formula, edit the formula to:

    Duration = if(isblank(Table[dated]),blank(),DATEDIFF('Table'[Start Date],'Table'[Dated],DAY))

    The average should not be correct.

lbendlin's avatar
lbendlin
Super User
4 years ago

You can solve this by defining what should happen in such a case - should the data be excluded, or should the missing Close Date be substituted with "today"?