Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to extract the text before delimeter
06-09-2023
01:12 AM
Hi all,
I have a list of values and I want to separate the value by the delimeter so here is one example.
ex: yashashri.dhaware (analyst)
abcde (engineer )
so I want a result as --> yashashri.dhaware
abcde
Help me with theses.
Thanks
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
02:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
01:18 AM
Hi @YASHASHRI check
and https://learn.microsoft.com/en-us/powerquery-m/text-beforedelimiter
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
02:12 AM
Dataset that I have is taken by direct query hence i cant do the operation in power query editor.
want a dax for that.

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-06-2024 05:14 AM | |||
10-31-2024 06:01 PM | |||
03-26-2024 03:17 AM | |||
07-21-2021 09:34 AM | |||
03-07-2024 09:53 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |