Custome column to concatenate 4 columns which has text and date; date should be in changed to value

[Learner1585]

Hi,

I want to create a new custom column by concatenating below 4 columns

1.  Number ( as it is)
2. Date ( change to number before concatanating for eg 01 Aug 2023 = 45139)
3. Number/Text ( as it is)
4. Date ( change to number before concatanating for eg 01 Aug 2023 = 45139)

Below screenshot shows the column name and final uid filed which is the desired output.

Thank you.

[AlienSx · Accepted solution]

Hi, @Learner1585 [Code] goes last in your desired output

    uid = Table.AddColumn(
        your_table, "UID", 
        each [ID] & Text.From(Number.From([ActivityDate])) & Text.From(Number.From([Calendar Day])) & [Code]
    )

[Learner1585]

Great and its you again @AlienSx  helping me out.

Cheers