cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lcasey Member
Member

Create a column that only returns SLS #

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:

 

 

 

DOCNUMBRDOCDATE Returned
3213411/17/2009 0:00 
SLS0081233/31/2009 0:00SLS008123
SLS01693012/18/2012 0:00SLS016930
366149/7/2010 0:00 
3667610/7/2010 0:00 
SLS0115429/7/2010 0:00SLS011542
690615/4/2016 0:00 
SLS 0241664/14/2016 0:00SLS 024166
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Create a column that only returns SLS #

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!

1 REPLY 1
Super User
Super User

Re: Create a column that only returns SLS #

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!