Convert date in string format into date format?

[Anonymous]

Hello!

I'm new to Power BI, and was tasked to create some dashboards since I have previous software engineering experience.

I'm pulling data from Snowflake and the date column is unfortunately in string format (e.g. 2024-01-01)

I'm trying to convert it to mm/dd/yyyy as a Date datatype, and I'm not entirely sure how to do that. I'm pulling in the data using DirectQuery so I assume I have to create a new column and transform the data that way.

One solution I can think of is split the text by "-" delimeter into 3 columns, then merge the columns into one new column.

But is there a way to do this without having to create 4 new columns? Maybe one line of code can accomplish this?

Thanks in advance!

[Anonymous]

@lbendlin ,Thanks for the quick reply, your approach is correct, I will add further.

Hi @Anonymous ,

Please follow these steps:

1. Right-click the table that needs to change the date format

2. Use the following DAX expression to create a column named 'Date(mm/dd/yyyy)', [Date] is the date column in your table

Date(mm/dd/yyyy) = DATEVALUE('Tabelle1'[Date])

3. Select the newly created column

4. Final output

[Anonymous]

Thanks for the input! I tried this but I'm getting a

"We couldn't fold the expression to the data source". This is probably because I'm using DirectQuery.

[lbendlin]

Ignore Power Query.  Do the transform in DAX using DATEVALUE()