Merge Column

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.

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