Forum Discussion

Khomotjo's avatar
Khomotjo
Helper II
1 year ago
Solved

Date Function Error

Hello Evveryone, I am trying to construct a date using the Date function. My data looks like this :   My calculated coloumn looks like this :    WF_Finalised = DATE (StockMovements[P9_WhsW...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi Khomotjo  - Yes, you can create a new column in Power BI using DAX that extracts only the date part from a date-time column without using DATE() or formatting it directly from the toolbar. You can use the TRUNC function in DAX.

     

    Take a new column 

    DateOnly = TRUNC('TableName'[DateTimeColumn])

Khomotjo's avatar
Khomotjo
Helper II
1 year ago

Thanks rajendraongole1   Is there another way to create a column using only the date part without using  DATE() or formating directly from the tool bar( to make the date-time a short date)?

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Khomotjo  - Yes, you can create a new column in Power BI using DAX that extracts only the date part from a date-time column without using DATE() or formatting it directly from the toolbar. You can use the TRUNC function in DAX.

 

Take a new column 

DateOnly = TRUNC('TableName'[DateTimeColumn])