Forum Discussion

qmhernandez's avatar
qmhernandez
New Member
4 years ago
Solved

Adding a custum column based on an particular cell

Is there a way to add a dynamic custom column that returns the contents of a cell for the entire column? I need the conents of 'First Column' row 1 to become an entire row of duplicates without having to manually type it in as a custom column as I have done in the pictures below.

 

 

 

 

Need Help
  • KNP's avatar
    KNP
    4 years ago

    This should do the trick.

     

    let
  Source = Table.FromRows(
    Json.Document(
      Binary.Decompress(
        Binary.FromText(
          "i45WCkotSE0sSU1RCEvMKU1VitWJVnLMyy/JSC1CEknML07NK4Ewi/MzUkvywOz81KK8gtIUKLs4I6+ktAjMKU0pSs0H64gFAA==",
          BinaryEncoding.Base64
        ),
        Compression.Deflate
      )
    ),
    let
      _t = ((type nullable text) meta [Serialized.Text = true])
    in
      type table [Column1 = _t]
  ),
  #"Added Custom" = Table.AddColumn(Source, "Custom", each Source{0}[Column1])
in
  #"Added Custom"

1 Reply

  • KNP's avatar
    KNP
    Super User
    4 years ago

    This should do the trick.

     

    let
  Source = Table.FromRows(
    Json.Document(
      Binary.Decompress(
        Binary.FromText(
          "i45WCkotSE0sSU1RCEvMKU1VitWJVnLMyy/JSC1CEknML07NK4Ewi/MzUkvywOz81KK8gtIUKLs4I6+ktAjMKU0pSs0H64gFAA==",
          BinaryEncoding.Base64
        ),
        Compression.Deflate
      )
    ),
    let
      _t = ((type nullable text) meta [Serialized.Text = true])
    in
      type table [Column1 = _t]
  ),
  #"Added Custom" = Table.AddColumn(Source, "Custom", each Source{0}[Column1])
in
  #"Added Custom"