Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
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?
Solved! Go to Solution.
Add a new column to your employees able
Email = [FirstName] & "." & [Age] & "@gmail.com"
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
What is the email ID pattern?
First Name , age @gmail.com
Add a new column to your employees able
Email = [FirstName] & "." & [Age] & "@gmail.com"
thank you
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!