You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

Click Wizard Query, then select Simple Query Wizard, which lets you create a simple Query, Click OK. Choose the table and fields you want to put into your Query; click Next.

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.

Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI.