Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to create a date table so I can use quarters. I get the following DAX error, does anyone know how to fix this?
The syntax for 'Date' is incorrect. Date = (DAX(ADDCOLUMNS(CALENDAR("07-01-2011","06-30-2019'),"Date As Integer", FORMAT([Date],"YYYYMMDD"),"Month Number",FORMAT([Date],"mm"),"Year Month Short",FORMAT([Date],"mmm-YYYY"),"Year",FORMAT([Date],"YYYY"),"Month Name Long",FORMAT([Date],"mmmm"),"FY Month Year",FORMAT([Date],"mmm-yyyy"),"Day of Week",FORMAT([Date],"dddd"),"Day of Month",FORMAT([Date],"d"),"Day of Week Short",FORMAT([Date],"ddd"),"Quater","Q"& FORMAT([Date],"Q"),"Year Quarter",FORMAT([Date],"YYYY"&"/"& FORMAT([Date],"Q")))))
Solved! Go to Solution.
Never mind. I just found that I had a ' where a " needed to be.
Never mind. I just found that I had a ' where a " needed to be.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 67 | |
| 65 | |
| 56 |