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 |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |