Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Learner1585
Helper I
Helper I

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

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.

 

Learner1585_0-1697899990862.png

 

Thank you.

1 ACCEPTED SOLUTION
AlienSx
Super User
Super User

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]
    )

View solution in original post

2 REPLIES 2
AlienSx
Super User
Super User

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]
    )

Great and its you again @AlienSx  helping me out.

 

Cheers

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors