Forum Discussion

lynnzrae's avatar
lynnzrae
Icon for Helper I rankHelper I
2 years ago
Solved

DATEDIFF between two dates or if one date isn't given DATEDIFF between one date and today

I am creating a new column to identify the cycle time for projects. I want to create a formula so that I datediff from the start date to the complete date and if there is not a complete date (comple...
DATEDIFF
  • BeaBF's avatar
    BeaBF
    2 years ago

    lynnzrae Here the calculated column:

    Project Cycle Time_BBF =
    IF(
        ISBLANK('Table'[Project Complete Date]),
        DATEDIFF('Table'[Project Start Date], TODAY(), DAY),
        DATEDIFF('Table'[Project Start Date], 'Table'[Project Complete Date], DAY)
    )
    output:

     

    BBF

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

lynnzrae Here the calculated column:

Project Cycle Time_BBF =
IF(
    ISBLANK('Table'[Project Complete Date]),
    DATEDIFF('Table'[Project Start Date], TODAY(), DAY),
    DATEDIFF('Table'[Project Start Date], 'Table'[Project Complete Date], DAY)
)
output:

 

BBF