Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😀
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |