How to Compare Dates in Power BI
- George Apostolov
How to Compare Dates in Power BI: step-by-step guide
Click 'Transform data' from the 'Home' tab.
In the Power Query Editor, click 'Add Column'.
Choose 'Custom Column'.
Add the custom column formula in the empty field.
Click 'OK' to apply the formula.
Following these steps, filter rows where the date is greater than today.
Click the 'File' menu and select 'Close & Apply'.
Quick answer: To compare dates in Power Query Editor, click Transform data from the Home tab, select Add Column, and choose Custom Column. Next, add the custom column formula, click OK, filter rows where the date is greater than today, and select Close & Apply from the File menu.
About this Power BI tutorial
Filter and compare dates efficiently in Power BI by adding a custom formula in the Power Query Editor and applying changes. This guide shows how to compare Dates in Power BI in 7 steps, starting with "Click 'Transform data' from the 'Home' tab" and finishing with "Click the 'File' menu and select 'Close & Apply'". 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 Dates in Power BI?
7 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 Months in Power BI, How to Compare Two Measures in Power BI and How to Connect a Smartsheet Document to Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
