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"

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.