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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

If the number of digits in the bracket are always of 3 digits, then you may use Column By Example in the Query Editor.