Table of Contents
In Power BI, you can use the DATE function to extract the date from a datetime value. This function takes in the datetime value as an argument and returns the date portion of it. You can also use the FORMAT function to specify the format in which you want the date to be displayed. This allows you to manipulate the date and use it for analysis or visualization purposes in your Power BI reports and dashboards.
You can use the following syntax in DAX to extract the date from a datetime in Power BI:
date = FORMAT('my_data'[Datetime], "M/D/YYYY")
This particular example creates a new column named date that extracts the date from the column named Datetime in the table named my_data.
The following example shows how to use this syntax in practice.
Example: How to Extract Date from Datetime in Power BI
Suppose we have the following table named my_data in Power BI that contains information about total sales made by some company at specific datetimes:
Suppose that we would like to extract the date from each datetime in the Datetime column.
To do so, click the Table tools tab, then click the icon called New column:
Then type the following formula into the formula bar:
date = FORMAT('my_data'[Datetime], "M/D/YYYY")
This will create a new column named date that contains only the date from the the corresponding datetime in the Datetime column:
For example:
- The formula extracts 1/1/2024 from 1/1/2024 10:15:00 AM.
- The formula extracts 1/5/2024 from 1/5/2024 7:15:23 PM.
- The formula extracts 2/15/2024 from2/15/2024 1:15:09 AM.
And so on.
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: