In order to utilise the time-based functionality of PowerBI, you'll need to add a Date Table to the data model. This can be done through a few different methods. The easiest way to do this is to use DAX to generate the table and associated columns. One way of doing this is described below. To download the file created in this example, click here. Click 'Modelling' in the menu bar Click 'New Table' in the menu When the formula bar appears, enter DateTable = CALENDAR (date(2010, 1, 1) , today()) as shown below This will now create a table with one row per date, from the 1st of January, 2010 to the current date. To see this table, click the 'Data' icon on the left hand side of the screen You will then see the following table, with a list of dates as described previously In order to develop your date table to provide additional columns, such as day number, week number, day name, month, etc, one method is to use the GENERATE function. In order to add an additio...
