# How to Compare Months in Power BI

> To compare months in Power Query, navigate to the Home tab and select Transform data. Click Add Column, select Custom Column, type the formula in the empty field, and click OK to save changes.

Canonical: https://livedemo.ai/tutorials/how-to-compare-months-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3311ab56e05a00fd6fe3/preview?step=1

## Steps

1. From your 'Home' tab, select 'Transform data'.
2. Compare months in Power Query and click 'Add Column'.
3. Select 'Custom Column'.
4. Type the custom column formula in the empty field.
5. Click 'OK' to save changes.