Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax problem

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?

Need Help
  • Mohammad_Refaei's avatar
    Mohammad_Refaei
    4 years ago

    Add a new column to your employees able

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

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      First Name , age @gmail.com

      • Mohammad_Refaei's avatar
        Mohammad_Refaei
        Solution Specialist
        4 years ago

        Add a new column to your employees able

        Email = [FirstName] & "." & [Age] & "@gmail.com"
  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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