Anyone know how to parse a text and store in a new column

[Anonymous]

Hi, I have been trying to find out the best way of parsing out the mfg lot from a group of serial numbers. Four consecutive numbers (Place values are 7-10, As shown below)

First two place are for the week and the second two the year. Can anyone show me how to accomplish this? A Dax calculation? Something?

[Ashish_Mathur]

Hi,

This calculated column formula should work

=mid(Data[text],7,4)

[KNP · Accepted solution]

Hi @Anonymousl, 

This should do the trick...

let
  Source = Table.FromRows(
    Json.Document(
      Binary.Decompress(
        Binary.FromText("i45WMjAyNjXyMDUwNPcwMDC1MFaKjQUA", BinaryEncoding.Base64), 
        Compression.Deflate
      )
    ), 
    let
      _t = ((type nullable text) meta [Serialized.Text = true])
    in
      type table [Column1 = _t]
  ), 
  #"Changed Type" = Table.TransformColumnTypes(Source, {{"Column1", type text}}), 
  #"Inserted Text Range" = Table.AddColumn(
    #"Changed Type", 
    "Text Range", 
    each Text.Middle([Column1], 6, 4), 
    type text
  )
in
  #"Inserted Text Range"

The key is the Text.Middle. 

Hope this helps.

[Anonymous]

Thank you! It worked perfect!!