Forum Discussion

ResearchDev's avatar
ResearchDev
Icon for Helper II rankHelper II
4 years ago
Solved

Trying to calculate Days between 2 date columns. Both Columns have nulls or no values

There is Actual Start and Actual End Date. Both columns have null values as project is in progress or no given date. Keep getting errors on below. Any suggestions? Just trying to get a number value o...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi ResearchDev 
    PLease try

    Days Between =
IF (
    'BI Projects'[Actual Start] <> BLANK ()
        && 'BI Projects'[Actual End] <> BLANK (),
    DATEDIFF ( 'BI Projects'[Actual Start], 'BI Projects'[Actual End], DAY )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi ResearchDev 
PLease try

Days Between =
IF (
    'BI Projects'[Actual Start] <> BLANK ()
        && 'BI Projects'[Actual End] <> BLANK (),
    DATEDIFF ( 'BI Projects'[Actual Start], 'BI Projects'[Actual End], DAY )
)
  • ResearchDev's avatar
    ResearchDev
    Icon for Helper II rankHelper II
    4 years ago

    Thanks so much!