Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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 con...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago
    Text.From([Column) & Text.From([Column2]) & Text.From([Column3])
Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

 

hi Anonymous

 

YearColumn = YEAR(TablewithDate[DateField])

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Vvelarde

    I tried this but it did not work

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      10 years ago

      Date.Year (DateField)

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

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