Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Solved! Go to Solution.
@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
That will only make sense if you can provide the start date as well.
@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
Thanks you, this has helped so much 😀