Year and Month within a column CALENDARAUTO()

[Anonymous]

Dear all,

I recently created a calendar table with the CALENDARAUTO() function for my PowerBI report.  However, I'm not very good with DAX and I followed a youtube tutorial in order to create it. I tried to insert a column that would give me the month and year. I tried something as you can see on the attached screenshot but it doesn't work. Can anyone tell me what to write?

Thank you very much in advance.

[Anonymous]

Thank you, it worked ! 

[johnt75 · Accepted solution]

It needs to be YEAR([Date]) & MONTH([Date]).

The single & is the operator to append strings, the double && is a logical AND.