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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
PeterNowak
Frequent Visitor

Excel formula to DAX / maybe other solution (?)

Hello,

 

I would like to create in PowerBI additional column which will be based on exisitng column and we would see here just text after special character. In my case it's "#".

 

For example

Column A: TEST #DONE

Column B (the new one): #DONE

 

In excel I used below formula:

=IFERROR(RIGHT(A2200;LEN(A2200)-FIND("#";A2200));"-")

 

Thanks for help!

1 ACCEPTED SOLUTION

Hi @PeterNowak ,

 

Create a calculated Column

 
 
Valuess =

var search = SEARCH("#",'Table'[Split],, LEN('Table'[Split]))
RETURN
RIGHT('Table'[Split],LEN('Table'[Split])- search)
 
1.jpg
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

3 REPLIES 3
harshnathani
Community Champion
Community Champion

Hi @PeterNowak ,

 

 

You can do this is Power Query.

 

1.jpg

 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Hi @PeterNowak ,

 

Create a calculated Column

 
 
Valuess =

var search = SEARCH("#",'Table'[Split],, LEN('Table'[Split]))
RETURN
RIGHT('Table'[Split],LEN('Table'[Split])- search)
 
1.jpg
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

@PeterNowak ,

 

You can also look at this video.

 

https://www.youtube.com/watch?v=Tkqc5pOWAKY&t=112s

 

 

Regards,

Harsh Nathani

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.