Text matching

[Anonymous]

Hi,

I am trying to calculate

If Part no contains 0 or - or both then print part no to the K-parts column.

[ryan_mayu · Accepted solution]

@Anonymous 

you can also try to create a column

Column = 
VAR a=find("0",'Table (2)'[Part No],1,0)
VAR b=find("-",'Table (2)'[Part No],1,0)
return if(a=0&&b=0,"NA",'Table (2)'[Part No])

I am not sure why your last row contains 0, but your expected result is NA.

[Anonymous]

@ryan_mayu Thank you for your help.

My bad.. the last row should be NA.

[lbendlin]

Your last sample line is inconsistent.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8jY0MjbRNTQ2MTVTitWJVgJxTc3MwWwgy8DSwhsu7u0ZomtmbmoCETEzt7A0MFSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Part No" = _t]),
    #"Added Custom" = Table.AddColumn(Source, "K- parts", each if Text.Contains([Part No],"-") or Text.Contains([Part No],"0") then [Part No] else "NA")
in
    #"Added Custom"

  Anyway, here's the formula. Power Query is pretty verbatim.  

[Anonymous]

@Syndicate_Admin

Can you show me in pbix file?