How to Convert Date to Text in Power BI

In this Power Bi tutorial, We will discuss how to convert Date to Text in Power BI. In addition, we will also discuss how to convert Date to Text using Power BI DAX in Power BI.

Moreover, we will also cover the below-mentioned headings:

Power BI convert date to text YYYYMMDD
Power Query date.totext example
Power BI change date to month and year
Power Query converts date to text

Also, Read: Power BI Conditional Formatting Positive and Negative Numbers

Table of Contents:

Power BI converts date to text

Here we will see how to convert the date data type to text data type in Power Bi,

Yes, it is possible to convert the date data type to a text data type in Power BI using DAX expression.

We will use the financials data table in this example, to convert the Date column which is of date data type to the text data type in Power Bi.

Steps to follow to convert the date data type to a text data type in Power BI

Load the financials data table into the Power Bi desktop using the get data option. Once the data has been loaded, check the Date column data type by selecting the Date column header, Column tools – > data type as highlighted below:

To convert the date data type to the text data type, simply expand the data type dropdown option and choose the text data type.

It will automatically converts the date column from the date data type to the text data type as highlighted below:

Example of Power BI converts date to text — Example of Power BI converts a date to text

This is how to convert the date data type to text data type in Power Bi.

Check out: Power BI Group by Column [With Various Examples]

Power BI convert date to text DAX

Let us see how we can convert the date to text DAX in Power BI

In this example, we will convert the date data type to text data type using DAX in Power BI.

Open the Power Bi desktop and load data into it using the get data option, select the new column under tables tools, and apply the below formula to convert a date data type to a text data type.

Date to Text = CONVERT(financials[Date],STRING)

Where,

Date to Text = New column name
CONVERT = Function Name
financials = Table Name
Date = Existing Column name with date data type

Once the DAX formula has been entered, select the check icon.
In the below screenshot, you can see that the new column displays the expected value with the text data type as highlighted:

This is how to convert the date to text DAX in Power BI.

Power BI converts date to text YYYYMMDD

Here we will see how we can convert the date to text YYYY MM DD in Power BI.

In this example, we will use the Power BI Date Format to convert the date data type to the text data type in Power BI.

Load data source into the Power BI desktop. Once the data has been loaded select Table Tools -> New column as shown below:

In the calculate column formula bar, apply the below-highlighted formula to convert the date data type to text data type YYYY MM DD.

YYYY MM DD Format = format([Date], "YYYY MM DD" )

Where,

YYYY MM DD Format = New column name
format= Function Name
Date = Existing Column name with date data type

Once the DAX formula has been entered, select the check icon.
The screenshot below displays the expected value with the text data type in the mentioned (YYYY MM DD format) as highlighted in the newly added calculated column.