Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm having issues with text funciton "find".
I use it to partition string into columns (to create table with couple of additions later)
The expression is Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);
"test";FIND("-";[pandl];1)+4
)
I'm getting error "The search Text provided to function 'FIND' could not be found in the given text."
I'm sure, the "-" mark is in my text, I used same expression before on same dataset and it was working.
Thanks for any ideas,
Zuzana
Solved! Go to Solution.
@Anonymous,
Please try the expression below
Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);"test";IF(ISERROR(FIND("-";[pandl];1)),BLAKN(),FIND("-";[pandl];1))+4)
Regards,
Chalrie Liao
@Anonymous,
Please try the expression below
Pandl_key2 = ADDCOLUMNS( SUMMARIZE(data;[pandl]);"test";IF(ISERROR(FIND("-";[pandl];1)),BLAKN(),FIND("-";[pandl];1))+4)
Regards,
Chalrie Liao
Hi Charlie,
thanks for your answer.. it worked well.
I found that there were some blank values, which probably caused this troubles. Your solution can fix this.
Best regards 🙂
Zuzana
Are you trying to find the starting position of the "-" and then plus 4?
So if it's 10-100-600331, the answer you will get is 3+4 = 7?
Try this:-
Pandl_key2 = FIND("-",[pandl],1)+4
Find Syntax is:-
FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |