Learn how to define and use date tables in Power BI

[bitheerani319]

Put Introduction to Power BI
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. You can use these built-in hierarchies when you create reporting features like visuals, tables, quick measures, slicers, and so on. Power BI Desktop generates this data by creating hidden tables on your behalf, which you can use for your reports and DAX expressions.

Many data analysts prefer to create their own date tables, and that's fine. In Power BI Desktop , you can specify the table that morocco mobile database want your model to use as its date table , and then create date-related visuals, tables, quick measures, and so on using date data from that table. When you specify your own date table, you control the date hierarchies that are created in your model and use them in quick measures and other operations that use your model's date table.

Screenshot of Power BI Desktop showing the dialog box

Define your date table
To define a date table , select the table that you want to use as a date table in the Fields pane , then right-click the table and choose Mark as Date Table > Mark as Date Table from the menu that appears, as shown in the following image.

Screenshot of Power BI Desktop showing the filter options

You can also select the table and then choose Mark as Date Table from the Table Tools ribbon shown here.