Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |