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) 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

 

Need Help

5 Replies

  • 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.