Column with date only

[kyleNN9000]

Hi,

Goal: looking for assistance to create and write dax code for a new column with date only from an existing column that has date and time.

Scenario: I have an existing column (screenshot) that has the date and time as the value. my data is connected via directquery.

Issue: I've tried many variations of dax code and none of them allow the data to populate correctly. Such as:

- date only column = DATEVALUE(LISTEMAIL[SCHEDULEDDATE])

- date only column = DATE(YEAR(LISTEMAIL[SCHEDULEDDATE]), MONTH(LISTEMAIL[SCHEDULEDDATE]), DAY(LISTEMAIL[SCHEDULEDDATE]))

any suggestions? thanks

[Kaviraj11]

You can try and setup as a new source.

Power Query Snowflake connector - Power Query | Microsoft Learn

[Kaviraj11]

Changing the data type of a column in Power BI while using Direct Query mode can be a bit tricky because Direct Query has some limitations. DirectQuery in Power BI - Power BI | Microsoft Learn

Are you using SQL Server as a Source?

If Yes, you can convert/cast the data type to Date in SQL Statement editor while connecting with server.

[kyleNN9000]

i'm not trying to change the data type of the exisiting column. i am trying to create a new column with only the date and not the time from the existing column.

[Kaviraj11]

Yes, I understand that. However, if you are reading it from SQL Server, you can create a new column using convert/cast to transform the datetime column to date. It will be created as a seperate column and you can utilize that column in your report.

[kyleNN9000]

oh i see now. okay yes, i'm connecting via snowflake. can i modify it after i already connected it or do i need to start the connection over from scratch?