Forum Discussion
Splitting columns by Delimiter with DAX (No Query Editor)
Hi, I have values in a column like, " Goext.wk.rainier.global". I would like to split the column by the right most delimiter so that the value in the column is just Goext. I know I can (and h...
Anonymous
For such modelling, It is always best to use split function in Query Editor, I am not sure why you are not able to do so.
The solutions are provided above with dax, but you should know this is not split column, it just find the text from the column values. In DAX it is kind of limited to if you only want the most LEFF/RIGHT value of delimiter.
RIGHT('Table'[Column],SEARCH(".",[Column],1,0))
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.