Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 normal value
data looks like this
123
456
425
458(548)
856
458
458(586)
any help is appreciated
thanks
Solved! Go to Solution.
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
Proud to be a Super User!
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.
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
Proud to be a Super User!
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |