Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
It needs to be YEAR([Date]) & MONTH([Date]).
The single & is the operator to append strings, the double && is a logical AND.
Thank you, it worked !
It needs to be YEAR([Date]) & MONTH([Date]).
The single & is the operator to append strings, the double && is a logical AND.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |