Forum Discussion

tijuemson's avatar
tijuemson
Frequent Visitor
5 years ago
Solved

returning value inside bracket

Hi guyz   i have the following values in a column  i want to make a calculated column where if there is a bracket then i want the value inside the bracket if there is no bracket then just the norma...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi tijuemson 

    Download this sample PBIX with solution

    To do this in a Calculated Column use this code

     

    Column = IF(CONTAINSSTRING('Table'[Data],"("),MID('Table'[Data],FIND("(",'Table'[Data])+1,FIND(")",'Table'[Data])-FIND("(",'Table'[Data])-1),'Table'[Data])

     

    Regards

    Phil

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

This is much easier in the query editor where you can use the button on the ribbon Extract button and Text Between Delimiters of ( and )

Pat