How to Get the Current Date in Power BI

Quick summary

The Power BI TODAY function lets you create a dynamic date measure that automatically updates every time your report refreshes. Using the Modeling tab and a simple DAX formula, you can display the current date without manual input.

Steps

1. Open your Power BI Desktop report where you need the current date function.
2. Navigate to the Modeling tab in the top ribbon.
3. Click the New Measure button to create a place for your date formula.
4. Enter the TODAY function in the formula bar to return the current date.
5. Press the check mark or hit Enter to commit your new date measure.
6. Your report now contains a dynamic date measure that updates automatically each time the report refreshes.