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.
You can also select the table and then select Mark as Date Table from the Modeling ribbon, shown here.
When you specify your own date table, you need to make sure the data type is properly set.
You want to set the Data type to Date/Time or Date.
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.
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.
I’ve already expressed my argument for why in two posts: one on how critical it is to find the right life partner and how seriously we should take that quest, and another on why going to bars is a terrible life experience.
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 then use those built-in hierarchies when creating report features like visuals, tables, quick measures, slicers, and so on.
Are you seeking Undertable arrangements with local swingers or wanting to find an adventurous partner for the lifestyle?
With 50000 members and ever growing in ASIA, get connected to genuine swingers straight up.
The following window appears, where you can select the column to use as the date table from the drop-down box.