Excel formula to DAX / maybe other solution (?)

[PeterNowak]

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!

[harshnathani]

Hi @PeterNowak ,

You can do this is Power Query.

Regards,
Harsh Nathani

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

[harshnathani · 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)

Regards,
Harsh Nathani

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

[harshnathani]

@PeterNowak ,

You can also look at this video.

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

Regards,

Harsh Nathani