Forum Discussion

User57639205's avatar
User57639205
Frequent Visitor
2 years ago
Solved

Converting Number to Years and Months

Is it possible to use a measure or similar to convert total years number value to months and dates?

I have a table showing max amount of days, ive created a measure to convert this to years but ideally would like it to show as 1 Year 2 months 5 Years 6 months etc. Is this possible?


 

Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    User57639205 Maybe this?

    Measure 2 = 
    VAR __Days = SUM('Table'[Column1])
    VAR __Year = TRUNC( DIVIDE( __Days, 365 ) )
    VAR __Months = TRUNC( MOD( __Days, 365 ) / 30 )
    VAR __Result = __Year & " Years " & __Months & " Months"
RETURN
    __Result

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    User57639205 Maybe this?

    Measure 2 = 
    VAR __Days = SUM('Table'[Column1])
    VAR __Year = TRUNC( DIVIDE( __Days, 365 ) )
    VAR __Months = TRUNC( MOD( __Days, 365 ) / 30 )
    VAR __Result = __Year & " Years " & __Months & " Months"
RETURN
    __Result
    • User57639205's avatar
      User57639205
      Frequent Visitor
      2 years ago

      Thanks you, this has helped so much ðŸ˜€

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    That will only make sense if you can provide the start date as well.