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

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!

  • 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)

3 Replies

  • 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)