2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range. If you haven’t formatted the data as a Table, Power Query will prompt you to do so.

Figure A This Excel PivotChart shows a YOY comparison of invoices for three years. These comparisons can be fairly easy or very complex depending on the how the business stores its data.