Power BI: How to Convert Date to YYYYMMDD Format

You can use the following syntax in DAX to convert a date to a YYYYMMDD format in Power BI:

Date_New = FORMAT('my_data'[Date], "YYYYMMDD")

The following example shows how to use this syntax in practice.

Example: Convert Date to YYYYMMDD Format in Power BI

Suppose we have the following table in Power BI named my_data that contains information about total sales made on various dates by some company:

Suppose we would like to convert the values in the Date column to a YYYYMMDD format.

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_New = FORMAT('my_data'[Date], "YYYYMMDD")

This will create a new column named Date_New that shows each of the corresponding date values from the Date column represented as text values in the format YYYYMMDD:

For example:

  • January 1, 2024 is shown as 20240101.
  • January 5, 2024 is shown as 20240105.
  • February 15, 2024 is shown as 20240215.

And so on.

Note: You can find the complete documentation for the FORMAT function in DAX here.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Convert Date to Text
Power BI: How to Convert Date to Month and Year
Power BI: How to Convert Date to Quarter and Year

Leave a Reply

Your email address will not be published. Required fields are marked *