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
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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors