Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
I am a little in a crisis about how to deploy or found a good command for reading a label between two marked characters of a tag
I have a text field, where generally is present somewhere the tag RCA_EN:<generic text># in this format
At this time I have deployed a formula able to find the tag "RCA_EN" in the cell but I am not able to find a way to read/print the value between the two delimiters
In attach and power bi file used for this example that respect the original
https://drive.google.com/file/d/1LHoTb5EaJ0fWTzZmWkwSlwCF6zYvuZGN/view?usp=share_link
thank you in advance for your help and suggestion
Solved! Go to Solution.
@flavio65
Apologies, I did not notice the link.
Please refer to attacjhed sample file with the proposed solution
Category =
PATHITEM (
SUBSTITUTE (
SUBSTITUTE ( 'Table'[Comment], "RCA_EN:", "|" ),
"#",
"|"
),
2
)
Hi tamerj1
Are you able to download the .pibx posted ??
In the while the raw data here
@flavio65
Apologies, I did not notice the link.
Please refer to attacjhed sample file with the proposed solution
Category =
PATHITEM (
SUBSTITUTE (
SUBSTITUTE ( 'Table'[Comment], "RCA_EN:", "|" ),
"#",
"|"
),
2
)
GREAT JOB
Not familiar with your suggestion Thank you !
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
9 | |
9 | |
6 | |
5 |
User | Count |
---|---|
19 | |
16 | |
10 | |
9 | |
8 |