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.
I have a field with below values.
SABBANK\O45678
SABBANK\345670
INDBANK\234090
SBIBANK\098765
I need to create a measure to give the below values present after "\". I need only measure and not a calculated column becausre the source is a live Power BI dataset connectivity.
O45678
345670
234090
098765
Please help.
Solved! Go to Solution.
@Anonymous I think:
Measure =
VAR __String = MAX('Table'[Column])
VAR __Slash = SEARCH("\",__String)
RETURN
MID(__String,__Slash+1,LEN(__String)-__Slash)
@Anonymous
Try this measure:
New Value =
Var _NoCh = search("\",FIRSTNONBLANK('Table'[Value],""))
Var _TEXT = FIRSTNONBLANK('Table'[Value],"")
return
right(_TEXT,LEN(_TEXT)-_NoCh)
The output will be as below:
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
I have the following base column source (actions)
- The theme is in different positions of the text and can have from 5 to 100 characters but if it has a similarity the dates are inside delimiter "( " ")" sometimes it is stuck to the text and sometimes not
How can I solve it?
ACTIONS | WHAT I WANT TO SEE |
SO-AND-SO OF SUCH THE (12/02/2019) CONCRETE THE BREAD | (12/02/2019) |
SO-AND-SO THE I DO NOT FINISH (12/02/2023) | (12/02/2023) |
SO-AND-SO THE DID NOT FINISH THE NEXT DAY OF GRADUATION (12/02/2023) | (12/02/2023) |
THANK YOU
@Anonymous
Try this measure:
New Value =
Var _NoCh = search("\",FIRSTNONBLANK('Table'[Value],""))
Var _TEXT = FIRSTNONBLANK('Table'[Value],"")
return
right(_TEXT,LEN(_TEXT)-_NoCh)
The output will be as below:
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
@Anonymous I think:
Measure =
VAR __String = MAX('Table'[Column])
VAR __Slash = SEARCH("\",__String)
RETURN
MID(__String,__Slash+1,LEN(__String)-__Slash)
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 |
---|---|
76 | |
72 | |
56 | |
38 | |
35 |
User | Count |
---|---|
83 | |
68 | |
59 | |
46 | |
45 |