https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-days-of-the-year-include-quot-0-quot/m-p/2643310#M77715 <P>Hello,</P><P>&nbsp;</P><P>I am looking for a dax expression (to include in calculated column) that will include the first nine days of the year with "0" prefix. 01, 02, 03 etc.</P><P>&nbsp;</P><P>Thank you in advance.</P> Sun, 17 Jul 2022 23:45:09 GMT matrix_user 2022-07-17T23:45:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-days-of-the-year-include-quot-0-quot/m-p/2643310#M77715 <P>Hello,</P><P>&nbsp;</P><P>I am looking for a dax expression (to include in calculated column) that will include the first nine days of the year with "0" prefix. 01, 02, 03 etc.</P><P>&nbsp;</P><P>Thank you in advance.</P> Sun, 17 Jul 2022 23:45:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-days-of-the-year-include-quot-0-quot/m-p/2643310#M77715 matrix_user 2022-07-17T23:45:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-days-of-the-year-include-quot-0-quot/m-p/2643399#M77721 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="329134" data-lia-user-login="matrix_user" class="lia-mention lia-mention-user">matrix_user</a>&nbsp;</P> <P>&nbsp;</P> <P>Check this link:<BR /><A href="https://community.powerbi.com/t5/Power-Query/change-number-format-in-query-editor/td-p/1576461" target="_blank">https://community.powerbi.com/t5/Power-Query/change-number-format-in-query-editor/td-p/1576461</A></P> <P>&nbsp;</P> <P>and you can find the days number and then change the format to have&nbsp;<SPAN>"0" prefix. 01, 02, 03 etc.</SPAN></P> <DIV> <DIV><SPAN>New Number = </SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>'Table'[Column1]</SPAN><SPAN>, </SPAN><SPAN>"00"</SPAN><SPAN>)</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN>output:<BR /></SPAN></SPAN><img /> <P>&nbsp;</P> <P>&nbsp;</P> <P>If this post <STRONG>helps</STRONG>, please consider <STRONG>accepting</STRONG><EM><STRONG>&nbsp;it as the solution&nbsp;</STRONG></EM>to help the other members find it more quickly.</P> <P><STRONG>Appreciate your Kudos!!</STRONG>&nbsp;</P> <P><A href="https://www.credly.com/users/vahid-doustimajd/badges" target="_blank"><img /></A></P> <P><A href="https://www.linkedin.com/in/vahid-dm/" target="_blank" rel="noopener noreferrer">LinkedIn</A> | <A href="https://twitter.com/VahidDMcom" target="_blank" rel="noopener noreferrer">Twitter</A> | <A href="https://www.vahiddm.com/" target="_blank" rel="noopener noreferrer">Blog&nbsp;</A>| <A href="https://www.youtube.com/channel/UCF-uQfGF8de-EWnR9b2UQhQ" target="_blank" rel="noopener noreferrer">YouTube</A><A href="https://www.youtube.com/channel/UCF-uQfGF8de-EWnR9b2UQhQ" target="_blank" rel="noopener noreferrer">&nbsp;</A></P> </DIV> </DIV> Mon, 18 Jul 2022 01:23:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-days-of-the-year-include-quot-0-quot/m-p/2643399#M77721 VahidDM 2022-07-18T01:23:41Z