You can use DAX to create a date table. SEE: Learn how to use Power BI in Outlook and Office for data storytelling. For this example, the function creates only a few columns, ...

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.