cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrainey Member
Member

Displaying Year & Months

I am trying to display the tenure for an employee. I have one DATEDIFF formula that calculates the years and one DATEDIFF formula that calculates the months. In a single column, how can I have it display like "4 years, 6 Months"? Wasn't sure if the CONCATENATE function could do that for me. Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Displaying Year & Months

Hi @mrainey

 

The CONCATENATE function should work, or you can just build a string like this

 

New column = 
  Table[Years]  & " years, " & Table[Months] & " Months"

You can be a bit smarter and include some IF statements to handle pluralisation etc. but you hopefully get the idea.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

1 REPLY 1
Super User
Super User

Re: Displaying Year & Months

Hi @mrainey

 

The CONCATENATE function should work, or you can just build a string like this

 

New column = 
  Table[Years]  & " years, " & Table[Months] & " Months"

You can be a bit smarter and include some IF statements to handle pluralisation etc. but you hopefully get the idea.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!