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 id...
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
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 ðŸ˜€