Forum Discussion

PeterNowak's avatar
PeterNowak
Frequent Visitor
6 years ago
Solved

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 Co...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)