Last answered:

13 Nov 2022

Posted on:

13 Nov 2022

0

dimDate creation using DAX Command

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

1 answers ( 0 marked as helpful)
Instructor
Posted on:

13 Nov 2022

0

ok, what is the question?

Submit an answer