Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Try
QUOTIENT('Get'[Age in Months],12) & " Yr " & " & " & MOD('Get'[Age in Months],12) & " Mth "
Thanks that works!
Which one has worked 🙂 ? You seem to have marked your reply as a solution. In case there is a different solution please post and mark that as a solution.
So what is your expected output? 3 Yrs & 35 Mth seems not right, but what do you want to display here? 2 Yrs and 11 Mth?
Yes, 2 Yrs and 11 Mth should be the expected output. Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |