Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
Hi @Anonymous
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.
Hi @Anonymous
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.