How To Add Current Date In Power Bi

In Power BI, you can add the current date by using the DAX function called TODAY(). This function returns the current date in the local timezone of the machine running Power BI.

To add the current date, follow these steps:

1. Open Power BI Desktop and open your report or create a new one.
2. Click on the “Modeling” tab in the ribbon at the top of the screen.
3. Click on the “New Measure” button in the “Calculations” group.
4. In the formula bar that appears, enter the following formula:

=TODAY()

5. Press Enter to apply the formula.
6. Power BI will create a new measure with the current date. You can give it a meaningful name by changing the name of the measure in the “Fields” pane.

For example, if you name the measure “Current Date”, you can now use it in visualizations to show the current date dynamically.

Here’s an example of how you can use the current date measure:

1. Drag a visual onto your report canvas, such as a card or a table.
2. Drag the “Current Date” measure into the values section of the visual.

When you refresh your data in Power BI, the visual will automatically update to show the current date.