Hi, I am working on an assignment using PowerPivot in Excel and one of the parts to do is to use DAX to make calculated column, WeekdayName, use =FORMAT(Sales[Date],"dddd"). I used the formula and it keeps coming back as there is an error. What am I doing wrong? Can you give me the correct way to imput the formula?

0 X Bb Upload Assignment X Using DAX to create X Linked Table and Re X Bb Hands-On 4_Blin P x [) DAX cheat sheet * *Hands-On 4_Businexactat sheet x C Conditional Format X + Recycle Bin What does Quick Quote Clifford Jager IMC - -> C coursehero.com/file/26743044/Hands-On-4-Business-Intelligence-Using-PowerPivot-in-Excel-20131pdf/?justUnlocked=1#/doc/qa this image... Questionn... JR C & C Ir. $1 0 5 - - 7 | Power Pivot for Excel - WeatherMashup (1).xlsx X ? Ha File Home Design 302 > WE Ask Questions Get Data Type : Auto (Whole Number) 24 2 AutoSum Diagram View D L 01 07 IMG Exp paste Format : General Clear All Sort by Create KPI Show Hidden 582238 Re Adobe Cargo Find Data Creati... claim-J 2017 OP88 Get External Refresh PivotTable Data Filters Column View Efx Calculation Area g PowerPivot in Excel Clipboard Formatting ort and Filter Find Calculations View W Missing [Calculated C.. fx =FORMAT(Sales[Date],"'dddd") Answers Date Net Sales FORMAT(Value, Format) Location Calculated Colu... @ Add Column 582238 In..energy up HPLJEN Deta M426fM42. 1 1/1/20... 2202 Airport #ERROR 2 1/2/20... 2896 Airport #ERROR (Ctrl) WE WE 3 1/3 /20 ... 659 Airport #ERROR Quiz Yourself 4 1/4/20... 3389 Airport #ERROR OLE >> T DUMENIL RODLEWIS 01.11.2017 doc0576562... IMG 5 1/5/20... 2219 Airport #ERROR at 6 1/6/20... 3265 Airport #ERROR tu 7 1/7/ 20 ... 1688 Airport #ERROR W Related al 8 1/8/20... 2833 Power Pivot for Excel ? X WE Documents 9 1/9 /20 ... 797 The Business_Pom CeperoE &0 HH & W Los 3197 X The syntax for 'dddd' is incorrect. (DAX( Freedman QOO App.. 10 1/10/2... FORMAT(Sales[Date],"dodd") Minin 11 1/11/2... 1267 12 1/12/2... 3020 The calculated column 'Table1[Calculated Column 1]' contains a syntax error. Provide a valid formula. Ask Expert Tutors W 13 1/13/2... 2611 OK and Add to Library Details > > You can ask 41 questions (will expire O) S HP HH & W N 14 1/14/2... 2070 Short Answer Just Carry Invoice Signed Do. Lette 15 1/15/2... 2132 Airport #ERROR 16 1/16 / 2 ... 2358 Airport #ERROR W W 17 1/17 / 2 ... 2076 Airport #ERROR More 18 1/18 / 2 ... 2837 Airport #ERROR ESSAY "Foam Master 2017 02 17 HW Note to Sha 19 1/19 / 2 ... 2353 Airport #ERROR Invoice Rick Net 20 1/20/2 ... 2315 Airport #ERROR 21 1/21/2... 1871 Airport #ERROR W W 27 1/22/ 2 . 3084 Airport #FRROR v ne, use PAPERCOUR APPORTION. AD Express HW Solutions N CAB CARD . Change.. LLCFMCSA McAfee Google AD Express IMG_13821 pr Table 1 security SC... Chrome Change .. Sh Record: 14 2 of 1,830 6: 8:|Answer WE This helps us match you with the right tutor Answers in as fast as 15 minutes Module 22 Resendez Attachment IMG_13831 Primary ... Express Inc 5:06 PM O ere W S o Address & Documents 8 ~ 48 9/29/2019 LJ