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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
annerogers
Helper I
Helper I

DAX error message

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")))))

1 ACCEPTED SOLUTION
annerogers
Helper I
Helper I

Never mind.  I just found that I had a ' where a " needed to be.

View solution in original post

1 REPLY 1
annerogers
Helper I
Helper I

Never mind.  I just found that I had a ' where a " needed to be.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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