Need Dax Query for Below requirement Getting the some value or text from column where specific charecter is there Ex: 234#val*val1 13#val*0.001 Ans: 234 13 Make All values in to a new column