Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am Looking for a way to do the following
The results are highlighted in Yellow.
The Lookup Array would be the Well Name
Find a Match in the Origin Column and Destination Column
Pull the Last 2 Characters from the Matching Name
Solved! Go to Solution.
@Anonymous -
This could do the trick as a column:
Column =
VAR searchOne =
SEARCH ( TableName[Well], TableName[Origin], 1, FALSE () )
VAR searchTwo =
SEARCH ( TableName[Well], TableName[Dest], 1, FALSE () )
VAR Result =
IF (
searchOne,
RIGHT (
TableName[Origin],
( LEN ( TableName[Origin] ) - FIND ( ",", TableName[Origin], 1 ) - 1 )
),
IF (
searchTwo,
RIGHT (
TableName[Dest],
( LEN ( TableName[Dest] ) - FIND ( ",", TableName[Dest], 1 ) - 1 )
),
BLANK ()
)
)
RETURN
Result
Proud to be a Super User!
@Anonymous -
This could do the trick as a column:
Column =
VAR searchOne =
SEARCH ( TableName[Well], TableName[Origin], 1, FALSE () )
VAR searchTwo =
SEARCH ( TableName[Well], TableName[Dest], 1, FALSE () )
VAR Result =
IF (
searchOne,
RIGHT (
TableName[Origin],
( LEN ( TableName[Origin] ) - FIND ( ",", TableName[Origin], 1 ) - 1 )
),
IF (
searchTwo,
RIGHT (
TableName[Dest],
( LEN ( TableName[Dest] ) - FIND ( ",", TableName[Dest], 1 ) - 1 )
),
BLANK ()
)
)
RETURN
Result
Proud to be a Super User!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |