Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Column with date only

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) t...
Need Help
Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Kaviraj11
      Solution Sage
      2 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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?