Forum Discussion

sivasrao's avatar
sivasrao
Icon for Helper III rankHelper III
3 years ago
Solved

Date_Trunc Function in Power BI

Hi,

Anyone, please explain how can we use the Date_Trunc() function of SQL in Power BI.

 

Thank you in advance.

 

  • sivasrao , Datevalue

     

    Datevalue([Datetime])

     

    or

     

    Date(year([Datetime]) ,month([Datetime]), day([Datetime]))

1 Reply

  • sivasrao , Datevalue

     

    Datevalue([Datetime])

     

    or

     

    Date(year([Datetime]) ,month([Datetime]), day([Datetime]))