How to Compare Months in Power BI
- George Apostolov
How to Compare Months in Power BI: step-by-step guide
From your 'Home' tab, select 'Transform data'.
Compare months in Power Query and click 'Add Column'.
Select 'Custom Column'.
Type the custom column formula in the empty field.
Click 'OK' to save changes.
Quick answer: 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.
About this Power BI tutorial
Compare months in Power BI by transforming data, adding a custom column, and entering your formula in Power Query. This guide shows how to compare Months in Power BI in 5 steps, starting with "From your 'Home' tab, select 'Transform data'" and finishing with "Click 'OK' to save changes". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to compare Months in Power BI?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Compare Two Measures in Power BI, How to Connect a Smartsheet Document to Power BI and How to Connect Jira to Power Bi. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
