Dax problem

[Anonymous]

I have an employee details table without their email addresses so, there is a requirement for making their Email address. 

what Dax should I write? 

Employee table's Columns are: - FirstName, LastName, Age, Country, City, Department, Salary. 

Now I have to write any dax which can create email addresses without typing one by one. what to do?

[v-henryk-mstf]

Hi @Anonymous ,

Does @Mohammad_Refaei  solution solve your problem? If so, please mark the correct response as the standard answer to help the other members find it more quickly. If there is still confusion, please point out.

Best Regards,
Henry

[Mohammad_Refaei]

What is the email ID pattern?

[Anonymous]

First Name , age @gmail.com

[Mohammad_Refaei · Accepted solution]

Add a new column to your employees able

Email = [FirstName] & "." & [Age] & "@gmail.com"

[Anonymous]

thank you