topic Year and Month within a column CALENDARAUTO() in DAX Commands and Tips

Year and Month within a column CALENDARAUTO()

Anonymous — Wed, 30 Mar 2022 12:39:08 GMT

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.

Re: Year and Month within a column CALENDARAUTO()

johnt75 — Wed, 30 Mar 2022 13:06:09 GMT

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

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

Re: Year and Month within a column CALENDARAUTO()

Anonymous — Thu, 31 Mar 2022 09:04:41 GMT

Thank you, it worked !