Last answered:

20 Apr 2021

Posted on:

20 Apr 2021

0

the dim_Date is not included in the excel sheet as a table to see it in the power pi as you show in

the dim_Date is not included in the excel sheet as a table to see it in the power pi as you show in the video??!!

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

20 Apr 2021

0

Hi Peter, you are correct, the dim_Date table is using the dim_Date syntax that was covered earlier in the course. Please create a table using this code:
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"),
"Quarter", FORMAT([Date], "Q"),
"YearQuarter", FORMAT([Date],"YYYY")&"/Q"&FORMAT([Date],"Q"))

Posted on:

20 Apr 2021

1

Thx A lot, I know it should be created and I know how to create it but just Thought if there is something wrong wz me, Anyway thanks a lot again for your prompt reply

Submit an answer