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,
2019-03-01-PID 004-327-659 - 12851 Bathgate Way, Richmond.pdf
I have a column of unstructured data as mentioned above, and i was wondering if there is a way to create a new column and only display the data in red. All the rows have the words "PID" in them.
thanks,
Solved! Go to Solution.
The error happens if Name2 does not contain "PID"
So we can modify the formula to return blank if the search value is not found
pidcolumn =
The format of required part is PID nnn-nnn-nnn
If this is always the case, then you can add a calculated column with the following formula
newColumn =
Correction..
newColumn =
it didn't work.
@yelsherif wrote:Correction..
newColumn =
var leftPosition = FIND("PID",[sourceColumn])returnmid([sourceColumn],leftPosition,15)
@yelsherif wrote:Correction..
newColumn =
var leftPosition = FIND("PID",[sourceColumn])returnmid([sourceColumn],leftPosition,15)
@yelsherif wrote:Correction..
newColumn =
var leftPosition = FIND("PID",[sourceColumn])returnmid([sourceColumn],leftPosition,15)
The error happens if Name2 does not contain "PID"
So we can modify the formula to return blank if the search value is not found
pidcolumn =
thank you so much. it worked
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 |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |