Forum Discussion

alihijazi's avatar
alihijazi
Icon for Helper I rankHelper 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