Forum Discussion

fabd's avatar
fabd
Helper I
3 years ago
Solved

Extract string from collumn to a new collumn

Hello Community,   I am trying to convert an excel function to Power BI. Excel is good, but i need Power BI to automate some stuff. In excel the function is text.before and text.after (appeared in...
  • fabd's avatar
    3 years ago

    YEAH that's right.

     

    I found the solution by using, in the transform data GUI, the add collumn function and then extract text before and after.

     

    Thats the same function that has been implemented in excel. I was looking for it in PBI but i didn't look at the right place