dim_Date table creation in POWER BI
which key to skip to row 2 when typing DAX? Why not add anything in the first argument of the ADDCOLUMNS function, and go directly to define the columns?
1 answers ( 0 marked as helpful)
Hey Marta, To skip to a new row simply hold shift and press Enter. The ADDCOLUMNS function returns a table, so it needs to grab data from an existing table and aggregate it to return a new table. With the dim_Date we need to create consistency across the table for our time intelligence functions. In our fact_InternetSales table we have dates, but not for every single day so we cannot create a dim_Date table because we lack consistency. We need to have all days from 1st until 31st. So that's why we are calling the CALENDAR function which creates a range between start and end date, and essentially this is our first argument. From there we create all the additional attributes such as Quarter, Year and Month columns. Dimitar