Date_Trunc function

[sivasrao]

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?

[ValtteriN]

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/