Create a column that only returns SLS #

[lcasey]

Hello,

How can I use DAX to look through ALL the DOCNUMBR column, and ONLY IF it contains the Letters "SLS" return the full SLS document number only in the column?

This is what I am trying to do:

DOCNUMBR	DOCDATE	Returned
32134	11/17/2009 0:00
SLS008123	3/31/2009 0:00	SLS008123
SLS016930	12/18/2012 0:00	SLS016930
36614	9/7/2010 0:00
36676	10/7/2010 0:00
SLS011542	9/7/2010 0:00	SLS011542
69061	5/4/2016 0:00
SLS 024166	4/14/2016 0:00	SLS 024166

[KHorseman · Accepted solution]

Returned = IF(
	NOT(
		ISERROR(
			FIND(
				"SLS",
				TableName[DOCNUMBR]
			)
		)
	),
	TableName[DOCNUMBR],
	BLANK()
)

Man, I can't believe I got to use the NOT(ISERROR(FIND())) trick twice in one day!