Only perform column calculation if dependant column is not blank

[Anonymous]

I know this one sounds simple but my formula will not work with a =CALCULATE() argument so i'm struggling with a filter or ISBLANK.

My formula which works fine is 

Overall Policy Term (years/months) = (TODAY()-[Original Policy Start Date].[Date])/365

which is calculating a decimal value. However, if [Original Policy Start Date] is blank, the value is over 100. I want the calculation to only perform if [Original Policy Start Date] is not blank, else I want the cell to remain empty.

[d_gosbell · Accepted solution]

Couldn't you just do the following:

Overall Policy Term (years/months) = IF( NOT( ISBLANK( [Original Policy Start Date] )), (TODAY()-[Original Policy Start Date].[Date])/365 )

[AkhilAshok]

Maybe a simple if statmeent in the calculated column:

Overall Policy Term (years/months) =
IF (
NOT ( ISBLANK ( Table[Original Policy Start Date] ) ),
( TODAY () - Table[Original Policy Start Date] ) / 365
)