Forum Discussion
sivasrao
Helper III
Helper IIIDate_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]))
amitchandak
Super User
Super Usersivasrao , Datevalue
Datevalue([Datetime])
or
Date(year([Datetime]) ,month([Datetime]), day([Datetime]))