March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |