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?
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/
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/