Forum Discussion

alihijazi's avatar
alihijazi
Helper I
10 years ago
Solved

what's wrong with adding the below column?

hello I'm trying to add a column called Year which is gotten from a date column called Date check below:   However when I click OK I get that the YEAR is not recognized!!   Please ad...
Need Help
  • alexpancakes's avatar
    alexpancakes
    10 years ago

    Hi. You are in a Power Query editor (where you can edit the data from sources before loading it).

    There you need to user Power Query (M) language.

     

    So you have 2 ways to create Year.

    1) In Power Query editor use = Date.Year([Date])

    2) load data (home - close & load), then create a new column using DAX - there you can use formula you tried (sorry for russian):

  • SabineOussi's avatar
    SabineOussi
    10 years ago

    That is because you are using a wrong syntax.

    I will rename your Date column in question to SalesDate, the correct formula will be: Date.Year([SalesDate])

     

    For more info, these are the date functions that you can use in M

    https://msdn.microsoft.com/en-us/library/mt296606.aspx

alexpancakes's avatar
alexpancakes
Microsoft Employee
10 years ago

Hi. You are in a Power Query editor (where you can edit the data from sources before loading it).

There you need to user Power Query (M) language.

 

So you have 2 ways to create Year.

1) In Power Query editor use = Date.Year([Date])

2) load data (home - close & load), then create a new column using DAX - there you can use formula you tried (sorry for russian):

  • alihijazi's avatar
    alihijazi
    Helper I
    10 years ago

    got the below error; it didn't work for me!

     

    Please advise

    • SabineOussi's avatar
      SabineOussi
      Skilled Sharer
      10 years ago

      That is because you are using a wrong syntax.

      I will rename your Date column in question to SalesDate, the correct formula will be: Date.Year([SalesDate])

       

      For more info, these are the date functions that you can use in M

      https://msdn.microsoft.com/en-us/library/mt296606.aspx