Thereis no option of submitting assignment
dimDate = ADDCOLUMNS(
CALENDAR(MIN(fact_InternetSales[ShipDate]),MAX(fact_InternetSales[ShipDate])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Month Name", FORMAT([Date],"MMMM"),
"Day of Week", FORMAT([Date],"DDDD"),
"Quater", FORMAT([Date],"Q"),
"YearQuater", FORMAT([Date],"YYYY")&"/Q"&FORMAT([Date],"Q"))
dimDate = ADDCOLUMNS(
CALENDAR(MIN(fact_InternetSales[ShipDate]),MAX(fact_InternetSales[ShipDate])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Month Name", FORMAT([Date],"MMMM"),
"Day of Week", FORMAT([Date],"DDDD"),
"Quater", FORMAT([Date],"Q"),
"YearQuater", FORMAT([Date],"YYYY")&"/Q"&FORMAT([Date],"Q"))
dimDate = ADDCOLUMNS(
CALENDAR(MIN(fact_InternetSales[ShipDate]),MAX(fact_InternetSales[ShipDate])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Month Name", FORMAT([Date],"MMMM"),
"Day of Week", FORMAT([Date],"DDDD"),
"Quater", FORMAT([Date],"Q"),
"YearQuater", FORMAT([Date],"YYYY")&"/Q"&FORMAT([Date],"Q"))
I got a code very similar to the ones already shared by others.
There is no submit button for the assignment file
dimDate = ADDCOLUMNS(
CALENDAR(MIN(fact_InternetSales[ShipDate]),MAX(fact_InternetSales[ShipDate])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Month Name", FORMAT([Date],"MMMM"),
"Day of Week", FORMAT([Date],"DDDD"),
"Quater", FORMAT([Date],"Q"),
"YearQuater", FORMAT([Date],"YYYY")&"/Q"&FORMAT([Date],"Q"))
dim_Date = ADDCOLUMNS(
CALENDAR(MIN(fact_InternetSales[ShipDate]),MAX(fact_InternetSales[ShipDate])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Month Name", FORMAT([Date],"MMMM"),
"Day of Week", FORMAT([Date],"DDDD"),
"Quater", FORMAT([Date],"Q"),
"YearQuarter", FORMAT([Date],"YYYY")&"/Q"&FORMAT([Date],"Q"))