Forum Discussion

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

Date_Trunc function

Hi,

What is the equivalent DAX function for Date_Trunc() in SQL?

Or is there any alternate function that we can use the same as Date_Trunc() in Power BI?

 

1 Reply

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi,

    Here is one way to do this in dax:

    FORMAT(TRUNC(MAX('Calendar'[Date])),"dd/mm/yyyy")

    e.g. 

     


    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/