Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ramees_123
Helper IV
Helper IV

Measure to Extract specific characters from a String

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.

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@Ramees_123 I think:

Measure = 
  VAR __String = MAX('Table'[Column])
  VAR __Slash = SEARCH("\",__String)
RETURN
  MID(__String,__Slash+1,LEN(__String)-__Slash)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

VahidDM
Super User
Super User

@Ramees_123 
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:

VahidDM_1-1629983309236.png

 

 

 

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos VahidDM_0-1629983272306.png !!

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

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?

ACTIONSWHAT 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

VahidDM
Super User
Super User

@Ramees_123 
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:

VahidDM_1-1629983309236.png

 

 

 

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos VahidDM_0-1629983272306.png !!

Greg_Deckler
Super User
Super User

@Ramees_123 I think:

Measure = 
  VAR __String = MAX('Table'[Column])
  VAR __Slash = SEARCH("\",__String)
RETURN
  MID(__String,__Slash+1,LEN(__String)-__Slash)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.