Forum Discussion
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 advise
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):
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
4 Replies
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):
got the below error; it didn't work for me!
Please advise
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
alihijazi Trust me and try this http://community.powerbi.com/t5/Desktop/Token-eof-expected/m-p/27940
