Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DATEDIFF Calculation with Condition

Hi guys, I need a bit of help; please see the below example. I need Project Duration (Age) Calculation based on the below condition * If Project status is ''In Progress'''  or ''blank'' Calculate t...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Write this calculated column formula

    Duration = 1*(if(Data[Status]="Completed",[Contruction date]-[Start date],today()-[Start date]))

    Hope this helps.

mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

You can try a DAX calculated column with this expression

 

Duration =
IF(
    Table[Status] = "Completed",
    INT( Table[Construction Date] - Table[Start Date] ),
    INT( TODAY() - Table[Start Date] )
)

 

Pat