Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a text column where i want to pull a word from the column. There are no delimitors to pull from. For the screenshot, i want to pull either PAT or Auto from column B. The words PAT/Auto are not always at the end of the text value so it is really just pulling the word from anywhere in the value.
Thanks!
Solved! Go to Solution.
Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!
Found_Text = iferror(MID('table'[column], find("FPTS", '8HP_Tatoo_Today_Link'[TEXT_1]), 9), "")
Use a conditional column! Under Add Columns tab in Power Query Editor click conditional column and fill out the criteria!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |