Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have a requirement to split First and Last name from Fullname in direct query mode using DAX.
Hi @Mahipal ,
I made simple samples and you can check the results below:
First Name = PATHITEM(SUBSTITUTE(MAX('Table'[User Name]),",","|"),1)
Last Name = PATHITEM(SUBSTITUTE(MAX('Table'[User Name]),",","|"),2)
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Its working fine for import mode. Here we are using direct mode so the output is different as in the below image in direct mode
Can you find the query for direct mode.
Hi @Mahipal ,
It's strange, I used the solution @Dangar332 provided and I was able to get the right data.Did you create a calculated column instead of a measure?
Best regards,
Community Support Team_ Scott Chang
Thank you so much. Yes as measure this query is working. But I would like to have a query for Calculated Calumn as per our requirement.
Hi @Mahipal ,
As far as I know, there doesn't seem to be a way for this to be realized by calculating columns.
Best regards,
Community Support Team_ Scott Chang
Hello @Dangar332 your Query is working but results are not perfect. I am seeing same Name for all records.
hi, @Mahipal
you have any Unique identity on which we can add first name and last name in all rows.
and why cash,johnny only is there any specific condition?
I am using same query which you sent here. But the result is only one name. Here is query
hi, @Mahipal
try below code for measure
Firstname =
LEFT(
MIN('Table (2)'[Name]),
SEARCH(",",MIN('Table (2)'[Name]))-1
)
Last name =
RIGHT(
MIN('Table (2)'[Name]),
LEN(MIN('Table (2)'[Name]))-SEARCH(",",MIN('Table (2)'[Name]))
)
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If i modified that query from
I am still not getting proper results.
User | Count |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
25 | |
12 | |
11 | |
10 | |
6 |