Solved: Re: Calculate difference between dates, use TODAY ...

SophRow · ‎05-09-2023

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 months between tenure start date and today.

The output would be like:

Any ideas for a nice DAX formula?

Best,

Soph

Tahreem24 · ‎05-09-2023

@SophRow TRy this DAX Column:

Tenure Month =

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

RETURN DATEDIFF(Tenure Start Date, NewTermDate, MONTH)

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Tahreem24 · ‎05-09-2023

@SophRow TRy this DAX Column:

Tenure Month =

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

RETURN DATEDIFF(Tenure Start Date, NewTermDate, MONTH)

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Calculate difference between dates, use TODAY for blanks