https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Trunc-function/m-p/2912553#M95203 <P>Hi,</P><P>What is the equivalent&nbsp;<STRONG>DAX</STRONG>&nbsp;function for&nbsp;<STRONG>Date_Trunc()</STRONG> in SQL?</P><P>Or is there any alternate function that we can use the same as Date_Trunc() in Power BI?</P><P>&nbsp;</P> Thu, 17 Nov 2022 12:08:39 GMT sivasrao 2022-11-17T12:08:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Trunc-function/m-p/2912553#M95203 <P>Hi,</P><P>What is the equivalent&nbsp;<STRONG>DAX</STRONG>&nbsp;function for&nbsp;<STRONG>Date_Trunc()</STRONG> in SQL?</P><P>Or is there any alternate function that we can use the same as Date_Trunc() in Power BI?</P><P>&nbsp;</P> Thu, 17 Nov 2022 12:08:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Trunc-function/m-p/2912553#M95203 sivasrao 2022-11-17T12:08:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Trunc-function/m-p/2912606#M95207 <P>Hi,<BR /><BR />Here is one way to do this in dax:<BR /><BR /></P> <DIV> <DIV><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>TRUNC</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Calendar'</SPAN><SPAN>[Date]</SPAN><SPAN>)),</SPAN><SPAN>"dd/mm/yyyy"</SPAN><SPAN>)<BR /><BR /></SPAN>e.g.&nbsp; <P>&nbsp;</P> <img /><BR />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!<BR /><BR />My LinkedIn: <A href="https://www.linkedin.com/in/n%C3%A4ttiahov-00001/" target="_blank">https://www.linkedin.com/in/n%C3%A4ttiahov-00001/</A> <P>&nbsp;</P> </DIV> </DIV> Thu, 17 Nov 2022 12:35:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-Trunc-function/m-p/2912606#M95207 ValtteriN 2022-11-17T12:35:38Z