A date table in Power BI must meet the following requirements, whether it’s an Auto table or one you create: It must have a column named Date that’s a date/time data type. The Date column must ...

Otherwise, you’ll have to create the necessary relationships between the date (facts) table and the other tables to get the same results. SEE: Here’s how to create a dashboard in Power BI .