Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Year and Month within a column CALENDARAUTO()

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?

 

Capture d’écran 2022-03-30 143809.png

 

 

Thank you very much in advance.

 

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thank you, it worked ! 

johnt75
Super User
Super User

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

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors