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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vitexo87
Post Prodigy
Post Prodigy

create custom column concatenated

I'm fumbling create a custom column in a table that has already been loaded, this column will be used to relate that table to another, however I am unable to create this custom column.
I need to concatenate all the fields that are in the picture, I do not know what function and how to use, can someone help me?

 

Untitled.png

1 ACCEPTED SOLUTION

Text.From([Column) & Text.From([Column2]) & Text.From([Column3])



Lima - Peru

View solution in original post

10 REPLIES 10
Vvelarde
Community Champion
Community Champion

A Sample:

=[Segment] & Text.From([Count])

 

 

If you column is not a string use Text.From([Column]) else just the column name

 

 




Lima - Peru

Thanks for explaining why to use Text.From()

@Vvelarde

 

in my chance all the columns are of type int, as would be?

Text.From([Column) & Text.From([Column2]) & Text.From([Column3])



Lima - Peru

@Vvelarde

taking advantage, I have a date field that is in the format (dd / mm / yyyy hrs) and need to create a custom column from that field that presents only the yyyy, tried some string functions however nothing.

 

hi @vitexo87

 

YearColumn = YEAR(TablewithDate[DateField])

 

 




Lima - Peru

@Vvelarde

I tried this but it did not work

Untitled.png

Date.Year (DateField)




Lima - Peru
Sean
Community Champion
Community Champion

@vitexo87 an alternative that will generate the M formula @Vvelarde gave you above is

 

In the Query Editor => select your Date column => go Add Column tab => Date => Year => Year

(this will basically do the same thing)

 

QueryEditor - YEAR.png

Anonymous
Not applicable

I suspect "The Feature That We Don't Call Power Query" is the best place to do this (which is what folks are doing here) ... but you can also do this via a dax calculated column as well.

 

something like:

MyCalcColumn = MyTable[MyColumn1] & "-" & MyTable[MyColumn2] & "-" & YEAR(MyTable[MyDateColumn])

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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