Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Add Current Date in Power BI Dashboard

Cody Schneider••8 min read

Showing the current date on your Power BI dashboard is a simple but powerful way to add context and clarity for anyone viewing your report. It instantly answers the question, "Is this data for today?" and makes the dashboard feel more dynamic and professional. This article will walk you through the easiest and most effective ways to add an automatically updating current date to your Power BI reports using both DAX measures and Power Query.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Should You Add a Current Date to Your Dashboard?

Before jumping into the "how," let's quickly cover the "why." Adding a live date sounds simple, but it serves several important functions that improve the overall quality and usability of your reports.

  • Provides Immediate Context: A viewer instantly knows the frame of reference for the data. Seeing today's date confirms they are looking at a report that is current and relevant to the present moment.
  • Indicates Data Freshness: When placed alongside a "Last Data Refresh" timestamp, the current date helps users distinguish between when the underlying data was last updated and the moment they are viewing the report. This is critical for making accurate, timely decisions.
  • Enhances User Experience: It’s a small detail that removes ambiguity. Users don't have to guess or assume the report's timeframe, making for a smoother, more intuitive analysis experience.
  • Enables Dynamic Calculations: Having a live date measure allows you to create other dynamic calculations. For example, you can calculate Year-to-Date (YTD) or Month-to-Date (MTD) metrics that always use the current day as the endpoint, without needing to manually update formulas.

Method 1: Using DAX Functions (The Easiest Way)

For most scenarios, Data Analysis Expressions (DAX) offer the quickest path to adding a live date to your report. Power BI includes a couple of key functions for this exact purpose: TODAY() and NOW(). These are "volatile" functions, meaning they recalculate and update every time the report is opened or refreshed.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Using the TODAY() Function for Just the Date

The TODAY() function is perfect when you only need to display the current date without the time. It’s clean, simple, and the most common choice for this task.

Step-by-Step Instructions:

  1. Create a New Measure: Open your report in Power BI Desktop. In the main ribbon, navigate to the Modeling tab and click on New Measure.
  2. Enter the DAX Formula: The formula bar will appear. Type in the following simple DAX expression and press Enter. This creates a new measure named "Current Date" that will always hold today's date.
Current Date = TODAY()
  1. Format the Measure: A new measure called “Current Date” will now appear in your Data pane on the right. Click on it to select it. With the measure selected, a new Measure tools tab will appear in the ribbon. Here, you can change the format. For a clean, readable date, try the "Long Date" format (e.g., Sunday, August 4, 2024).
  2. Add the Date to Your Report: Go to your report canvas. The best way to display a single value like a date is with a Card visual. Select the Card visual from the Visualizations pane. Then, drag your newly created "Current Date" measure into the "Fields" area for that visual.

And that’s it! The card will now show the current date and will automatically update whenever a user opens the report.

Using the NOW() Function for Date and Time

If you need more granularity and want to show both the current date and the exact time, the NOW() function is what you need. It works just like TODAY() but includes the current time.

Step-by-Step Instructions:

  1. Create a New Measure: Again, go to the Modeling tab and click New Measure.
  2. Enter the DAX Formula: In the formula bar, type the following expression to capture the current date and time:
Current DateTime = NOW()
  1. Format the Measure: Select the "Current DateTime" measure in your Data pane. In the Measure tools tab, you can select a format that includes both date and time, or create your own custom format (e.g., m/d/yyyy h:mm AM/PM).
  2. Add to Your Report: Drag a Card visual onto your canvas and add the "Current DateTime" measure to it. You'll now see a timestamp that updates automatically.

TODAY() vs. NOW(): Which One Should You Use?

Choosing between the two is straightforward:

  • Use TODAY() for 90% of use cases. It's cleaner and most reports just need the date for context.
  • Use NOW() only when the specific time is relevant, for example, if you're tracking performance data that updates multiple times throughout the day and want to show the exact time of viewing.

Method 2: Using Power Query for a "Last Refreshed" Date

While DAX is great for showing the "view time," what if you want to show when the actual data was last refreshed? This is crucial for distinguishing between how current the data is versus when the user is viewing the report. For this, Power Query is the better tool.

A Power Query value updates only when you refresh the dataset, not every time the report is opened. This makes it a permanent timestamp of the last data ingestion.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Step-by-Step Instructions:

  1. Open the Power Query Editor: In the Power BI home ribbon, click on Transform data. This will open the Power Query Editor.
  2. Create a Blank Query: In the Power Query home ribbon, click New Source and select Blank Query.
  3. Enter the M Formula: With the new query selected, open the Advanced Editor. Replace the existing text with the following M code. This simple script creates a table with one column and one row containing the current timestamp.
let
    Source = #table(
        type table [LastRefreshDateTime = datetime], 
        {{ DateTime.LocalNow() }}
        )
in
    Source
  1. Name and Close: Click "Done". Rename the query on the right side to something descriptive like "Data Last Refreshed" and then click Close & Apply from the Home ribbon.
  2. Add it to Your Report: After Power Query loads the new table into your model, you'll see "Data Last Refreshed" in your Data pane. You can now drag the "LastRefreshDateTime" field into a Card visual just like you did with the DAX measure.

Now you have a timestamp that will only update when you refresh your data, giving users full transparency into how current the information really is.

Best Practices and Pro Tips

Once you have your date displaying, here are a few tips to make it even more effective.

1. Combine Date with Text for Better Labels

A card just showing a date is good, but a descriptive label is even better. You can create another DAX measure to combine text with your date function for a more polished look.

Create a new measure with a formula like this:

Date Header = "Report as of: " & FORMAT(TODAY(), "dddd, mmmm d, yyyy")

When you add this measure to a card or text box, it will display a clean, descriptive title like "Report as of: Monday, August 5, 2024".

2. Be Mindful of Positioning

Where you place the date matters. Good design suggests it should be visible but not distracting. Common and effective placements include:

  • In the top-right corner of the report header.
  • Subtly placed in the report footer.
  • Paired with the report title to ground the information in time (e.g., "Daily Sales Report - [Current Date]").

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

3. Account for Time Zones

Keep in mind that Power BI Service runs in Coordinated Universal Time (UTC). This means that a TODAY() or NOW() DAX function might return a different date/time depending on your local time zone. Power Query's DateTime.LocalNow() is based on the machine refresh occurs on (your machine for Desktop, or the gateway for the Service), providing more location-specific context for data refreshes. Be aware of this if your users are spread across different time zones.

Final Thoughts

Adding the current date to your Power BI reports is a quick-win that significantly boosts their professional feel and user-friendliness. Using DAX functions like TODAY() and NOW() is the fastest method for a live view-time date, whereas Power Query provides a reliable way to stamp your report with the last data refresh time. By combining both, you give your audience complete clarity on the data they're analyzing.

While mastering these details in Power BI is a great skill, sometimes the biggest challenge is getting all your marketing and sales data into one place for analysis. That's where we aimed to simplify things. Graphed connects directly to all your key data sources - from Google Analytics and Facebook Ads to Shopify and Salesforce - and lets you build real-time, interactive dashboards just by asking questions in plain English. Instead of wrangling CSVs or configuring BI tools, you get instant visibility without the technical overhead, allowing you to focus on the insights, not just the setup.

Related Articles