# How to Compare Dates in Power BI

> 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.

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

## Steps

1. Click 'Transform data' from the 'Home' tab.
2. In the Power Query Editor, click 'Add Column'.
3. Choose 'Custom Column'.
4. Add the custom column formula in the empty field.
5. Click 'OK' to apply the formula.
6. Following these steps, filter rows where the date is greater than today.
7. Click the 'File' menu and select 'Close & Apply'.