Use Power Query to calculate calendar quarter and calendar month.
Scenario:
* A single dataset must support all three reports:
- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.
- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.
* The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.