title: How to get user name from email address using DAX formula in SSAS tabular model
body: <p>I have a SSAS Tabular Cube an I am getting data from a underlying Database.</p>
  
  <p>I have a table Employee with columns:
  Job Title
  EmployeeID (Some numeric ID)
  Email Address
  Full Name
  Department</p>
  
  <p>I have email address like this
  Data in column - kunalshukla@yahoo.com (just example)</p>
  
  <p>Want to extract - kunalshukla and clear @yahoo.com</p>
  
  <p>I want a DAX formula which is simple to do this task</p>