Quick summary
This tutorial shows how to compare months in Power BI using Power Query by creating a custom column with a formula. Follow the step-by-step walkthrough to build month-over-month comparisons directly inside your Power BI data model.
Steps
- From your Home tab, select Transform data to open Power Query Editor.
- In Power Query, navigate to the Add Column tab to begin creating a new column.
- Select Custom Column from the Add Column menu.
- Type your custom column formula into the empty formula field to define the month comparison logic.
- Click OK to save the custom column and apply the changes to your data model.
