Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
9 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago
    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago
    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!