How can I split a text column using character space? I want to split “Name” into “First Name” and “Last Name”, and I’ve tried using the LEFT DAX function. But this function uses character count to split on. I did this one:
First Name = LEFT( 'Table1'[Name], SEARCH(" ", 'Table1'[Name], 0, LEN('Table1'[Name]) )
Can anyone give me some advice on how I could make this work? Or maybe I could use a different DAX function?
Thanks in advance!