Calculate Date Difference

[Anonymous]

Hi All,

I have the date in my data, need to find the age as on day in Bewlow Format.

Sample 

Date: 05/17/2018

Age as on Day : 1 Years, 0 Months (Format)

Regards.

[jdbuchanan71 · Accepted solution]

Something like this?

Measure = 
VAR TodaysDate = TODAY()
VAR MonthDiff = DATEDIFF ( SELECTEDVALUE ( Table1[date] ), TodaysDate, MONTH )
RETURN INT ( DIVIDE ( MonthDiff,12 ) ) & " years, " & MOD ( MonthDiff,12 ) & " months"

[Anonymous]

Thanks a lot it worked.

[Ashish_Mathur]

Hi,

Try this calculated column formula

=INT((TODAY()-[Date])/365)&"years, "&INT(MOD((TODAY()-[Date]),1))&" months"

Hope this helps.