Merge Column

[Mohammed-]

Hi

  Please need help for merge 2 column in the same table to create a ne culomn

  the new column should be include the following

       2004-01

       2004-02

       2004-03

      2004- 04

Thanks

  Mohammed

[v-yilong-msft · Accepted solution]

Hi @Mohammed- ,

I create a table as you mentioned in Data Factory.

Then I think you can create a custom column.

Custom = Text.From([Year]) & "-" & Text.PadStart(Text.From([Mon]), 2, "0")

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yilong-msft · Accepted solution]

Hi @Mohammed- ,

I create a table as you mentioned in Data Factory.

Then I think you can create a custom column.

Custom = Text.From([Year]) & "-" & Text.PadStart(Text.From([Mon]), 2, "0")

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mohammed- · Accepted solution]

Dir Sir,

   Thanks for your Replay

   I used your Formula

Table.AddColumn(#"Sorted rows", "Custom", each Text.From([Year]) & "-" & Text.PadStart(Text.From([Mon]), 2, "0"))

it is working fine with me

This is the result after some trasnformation

Thanks Again