Formula similar to ConcatenateX in Power BI

[Newbie777]

Hello,

I'd appreciate it if you could let me know if there are aggregate function of texts like ConcatenateX in Power BI.   I'd like to concatenate the employee names from the employee table with the calculation like number of years of tenure in a text string.  I am thinking something like below for the tenure expression which addresses the issue of multiple changes of departments for some employees:

and I'd like to combine the above with the employee name in a text string, so that I'd get a text string output like

Employee 1 (2 years), Employee 2 (15 years), Employee 3 (3 years)

I'd greatly appreciate your help.

Thanks,

[Newbie777]

OK. I found out that something like the expression below achieves the ConcatenateX effect in Qlik Sense.

Aggr(Concat(distinct([First name last name])&', '),[Department])

Regarding the tenure, I'd like the measure to respect the time dimension, and I am wondering instead of Today(2), which syntax I can use to indicate the max of the selected date from the time dimension, as the number of years of service is not static and changes with respect to the selected date in the time dimension.  

Thanks for your help.

[rwunderlich · Accepted solution]

Max(dateField)

[Newbie777]

Thanks a lot.  It works.