Last answered:

14 Mar 2023

Posted on:

14 Nov 2022

3

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

5 answers ( 0 marked as helpful)
Posted on:

14 Nov 2022

0

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

Posted on:

16 Nov 2022

0

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

Posted on:

16 Nov 2022

0

I got a code very similar to the ones already shared by others.

Posted on:

04 Dec 2022

0

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

Posted on:

14 Mar 2023

0

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

Submit an answer