Forum Discussion

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
6 years ago
Solved

Concat Year + Month

I have this measure: Age Year & Month = 'Get'[Age in Years] & " Yr " & " & " &'Get'[Age in Months] & " Mth "   This is obviously not the best way to show Year + Month, can you help me modify...
Need Help
  • diskovered's avatar
    diskovered
    6 years ago

    Thanks that works!

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
6 years ago

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?  

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
6 years ago

Yes,  2 Yrs and 11 Mth should be the expected output. Thanks