Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Date Difference

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.

 

 

 

 

 

 

 

 

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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"

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Try this calculated column formula

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

    Hope this helps.

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks a lot it worked.