![power bi download data table power bi download data table](https://dataap.org/wp-content/uploads/2021/05/ED.png)
The following window appears, where you can select the column to use as the date table from the drop-down box. You can specify which column to use by selecting the table in the Fields pane, then right-click the table and select Mark as date table > Date table settings. Once you specify a date table, you can select which column in that table is the date column.
![power bi download data table power bi download data table](https://i0.wp.com/blog.crossjoin.co.uk/wp-content/uploads/2013/11/image3.png)
The second scenario is where you use a table from Analysis Services, for example, with a dim date field that you want to use as your date table. This is a table in your data that meets the previously described validation criteria for a date table. The first scenario is when you use a canonical, or basic date table and hierarchy. There are two likely scenarios for creating your own date table, either of which is a reasonable approach: if it is a Date/Time data type, it has the same timestamp across each value.contains contiguous date values (from beginning to end).When you specify your own date table, Power BI Desktop performs the following validations of that column and its data, to ensure that the data: You can also select the table and then select Mark as Date Table from the Table tools ribbon, shown here. To set a date table select the table you want to use as a date table in the Fields pane, then right-click the table and select Mark as date table > Mark as date table in the menu that appears, as shown in the following image. When you specify your own date table, you control the date hierarchies created in your model, and use them in quick measures and other operations that use your model's date table. In Power BI Desktop, you can specify the table you want your model to use as its date table, and subsequently create date-related visuals, tables, quick measures, and so on, using that table's date data. Many data analysts prefer to create their own date tables, which is fine. Power BI Desktop does this by creating hidden tables on your behalf, which you can then use for your reports and DAX expressions.įor more information about this automatic behavior, read the Auto date/time in Power BI Desktop article. You can then use those built-in hierarchies when creating report features like visuals, tables, quick measures, slicers, and so on. Power BI Desktop works behind the scenes to automatically identify columns that represent dates, and then creates date hierarchies and other enabling metadata for your model, on your behalf.