Forum Discussion
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
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/
