https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508688#M29279 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="245032" data-lia-user-login="Sean-OReilly" class="lia-mention lia-mention-user">Sean-OReilly</a>&nbsp;</P> <P>= WEEKNUM(Table1[Won date], 2) &amp; "-" &amp;&nbsp; YEAR( Table1[Won date])</P> <P>&nbsp;</P> <P><STRONG>Please mark the question solved when done and consider <FONT color="#FF9900">giving a thumbs up if posts are helpful.</FONT></STRONG></P> <P><FONT color="#FF0000">Contact me privately for support with any larger-scale BI needs, tutoring, etc.</FONT></P> <P>Cheers&nbsp;</P> <P><img /></P> Sat, 21 Nov 2020 14:12:40 GMT AlB 2020-11-21T14:12:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508683#M29277 <P>Hi</P><P>How do i turn Won Date below into date format Week Number &amp; Year?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sat, 21 Nov 2020 14:03:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508683#M29277 Sean-OReilly 2020-11-21T14:03:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508688#M29279 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="245032" data-lia-user-login="Sean-OReilly" class="lia-mention lia-mention-user">Sean-OReilly</a>&nbsp;</P> <P>= WEEKNUM(Table1[Won date], 2) &amp; "-" &amp;&nbsp; YEAR( Table1[Won date])</P> <P>&nbsp;</P> <P><STRONG>Please mark the question solved when done and consider <FONT color="#FF9900">giving a thumbs up if posts are helpful.</FONT></STRONG></P> <P><FONT color="#FF0000">Contact me privately for support with any larger-scale BI needs, tutoring, etc.</FONT></P> <P>Cheers&nbsp;</P> <P><img /></P> Sat, 21 Nov 2020 14:12:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508688#M29279 AlB 2020-11-21T14:12:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508689#M29280 <P><BR /><BR />Week Num Year = FORMAT(WeekNum([Won Date]), "00") &amp;&nbsp;Year([Won Date])</P><P>&nbsp;</P><P>________________________</P><P>If my answer was helpful, please consider <STRONG><I>Accept it as the solution</I></STRONG><I> to help the other members find it</I></P><P>Click on the <STRONG>Thumbs-Up icon </STRONG>if you like this reply <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><A href="https://www.youtube.com/channel/UCKwBEguA8IlBubIobaOormg?sub_confirmation=1" target="_blank" rel="noopener"><FONT color="blue">YouTube</FONT></A>&nbsp; <A href="https://linkedin.com/in/fowmy" target="_blank" rel="noopener"><FONT color="blue">LinkedIn</FONT></A></P> Sat, 21 Nov 2020 14:18:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-turn-Date-into-Week-Number-and-Year/m-p/1508689#M29280 Fowmy 2020-11-21T14:18:32Z