Forum Discussion
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...
Hi,
Write this calculated column formula
Duration = 1*(if(Data[Status]="Completed",[Contruction date]-[Start date],today()-[Start date]))
Hope this helps.
Sorry My Bad. All good now thanks
You are welcome.