Quick summary
This tutorial shows how to compare dates in Power BI using the Power Query Editor and a custom column formula. You will learn to filter rows based on date conditions, such as identifying records where a date is greater than today.
Steps
- Click Transform data from the Home tab to open the Power Query Editor.
- In the Power Query Editor, click Add Column.
- Choose Custom Column from the Add Column menu.
- Add the custom column formula in the empty formula field.
- Click OK to apply the formula and create the new column.
- Use the steps to filter rows where the date is greater than today.
- Click the File menu and select Close & Apply to save your changes and return to the report.
