Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate difference between dates, use TODAY for blanks

Hi Experts,   I want to calculate Tenure in months and have a Tenure start date column and a Termination date column.    If the termination date column is blank, I want to calculate the number of...
Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    3 years ago

    Anonymous  TRy this DAX Column:

     Tenure Month = 

    VAR NewTermDate  = IF(TerminationDate=BLANK(), TODAY(),TerminationDate)

    RETURN DATEDIFF(Tenure Start Date, NewTermDate, MONTH)

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
3 years ago

Anonymous  TRy this DAX Column:

 Tenure Month = 

VAR NewTermDate  = IF(TerminationDate=BLANK(), TODAY(),TerminationDate)

RETURN DATEDIFF(Tenure Start Date, NewTermDate, MONTH)