How to Convert Date to Text in Power BI (2 Methods)


There are two ways to quickly convert a date column to a text column in Power BI:

Method 1: Use the Data Type Dropdown Menu in Column Tools

Method 2: Write a Custom DAX Function

The following examples show how to use each method in practice with the following table in Power BI:

Example 1: Convert Date to Text Using the Data Type Dropdown Menu

Suppose we would like to convert the Date column in the table from a date column to a text column.

One way to do so is to click on the header of the Date column, which will bring up the Column tools tab.

We can then click the Data type dropdown menu and then click Text:

This will convert the column from date to text:

Example 2: Convert Date to Text Using DAX

Another way to convert the Date column in the table from a date column to a text column is by writing a custom function in DAX.

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 = CONVERT('my_data'[Date], STRING)

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 mm/dd/yyyy:

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

Additional Resources

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

How to Count Number of Occurrences in Power BI
How to Use “If Contains” in Power BI
How to Write an IF Statement in Power BI

Leave a Reply

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