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)