what's wrong with adding the below column?

[alihijazi]

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 advise

[alexpancakes · Accepted solution]

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

[alexpancakes · Accepted solution]

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]

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

Please advise

[SabineOussi · Accepted solution]

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

[SabineOussi]

@alihijazi Trust me and try this http://community.powerbi.com/t5/Desktop/Token-eof-expected/m-p/27940