https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638191#M77395 <P>Could you pls attach the pbix?</P> Thu, 14 Jul 2022 09:01:41 GMT Anonymous 2022-07-14T09:01:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633576#M77138 <P>How to get the same period YTDs across any previous years in a single formula.</P><P>ie.&nbsp; across a Matrix like this, i want the June YTDs across all years :</P><P><img /></P><P>&nbsp;</P> Tue, 12 Jul 2022 11:59:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633576#M77138 Anonymous 2022-07-12T11:59:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633596#M77141 <P>Hello&nbsp;Anonymous</LI-USER>&nbsp; how are you?<BR />would it be like this?<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>Did I solve your problem?<BR />Please mark as solution so others can find this solution.<BR /><A href="https://www.linkedin.com/in/rodrigosanpbi/" target="_blank">https://www.linkedin.com/in/rodrigosanpbi/</A></P> Tue, 12 Jul 2022 12:09:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633596#M77141 rodrigosan 2022-07-12T12:09:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633628#M77144 <P>No I only want June YTD for all the years, ie. 2022 june YTD, 2021 June YTD,2020 June YTD etc in a single formula</P> Tue, 12 Jul 2022 12:17:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633628#M77144 Anonymous 2022-07-12T12:17:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633659#M77145 <P>I didn't understand the application very well.<BR />This result can be obtained from the filter.</P><P><img /></P><P>&nbsp;</P><P>Could you contextualize the objective?</P><P>&nbsp;</P><P>Did I solve your problem?<BR />Please mark as solution so others can find this solution.<BR /><A href="https://www.linkedin.com/in/rodrigosanpbi/" target="_blank">https://www.linkedin.com/in/rodrigosanpbi/</A></P> Tue, 12 Jul 2022 12:26:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2633659#M77145 rodrigosan 2022-07-12T12:26:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2635306#M77239 <P>Yes , but every month it should calculate automatically, so for next month it should calculate YTD August across all years, and then Sept YTD across all years so on.</P><P>&nbsp;</P> Wed, 13 Jul 2022 06:18:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2635306#M77239 Anonymous 2022-07-13T06:18:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2637382#M77356 <P>See if this is it:</P><P>***************************************************</P><DIV><DIV><SPAN>Month YTD = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>vMonth</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>[Sales Amount (YTD)]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'<span class="lia-unicode-emoji" title=":calendar:">📅</span>dCalendar'[Month]</SPAN><SPAN> = </SPAN><SPAN>vMonth</SPAN><SPAN><SPAN>)<BR />***************************************************<BR /></SPAN></SPAN><img /><P>&nbsp;</P><P><SPAN>Did I solve your problem?</SPAN><BR /><SPAN>Please mark as solution so others can find this solution.</SPAN><BR /><A href="https://www.linkedin.com/in/rodrigosanpbi/" target="_blank" rel="nofollow noopener noreferrer">https://www.linkedin.com/in/rodrigosanpbi/</A></P></DIV><DIV>&nbsp;</DIV></DIV> Wed, 13 Jul 2022 23:33:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2637382#M77356 rodrigosan 2022-07-13T23:33:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638191#M77395 <P>Could you pls attach the pbix?</P> Thu, 14 Jul 2022 09:01:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638191#M77395 Anonymous 2022-07-14T09:01:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638522#M77417 <P>can you share the formula</P> Thu, 14 Jul 2022 11:00:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638522#M77417 Anonymous 2022-07-14T11:00:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638552#M77421 <P>I inserted it in the answer below.<BR />It was this:</P><P>***************************************************</P><DIV><DIV><SPAN>Month YTD =</SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN>&nbsp;</SPAN><SPAN>vMonth</SPAN><SPAN>&nbsp;=&nbsp;</SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>TODAY</SPAN><SPAN>())</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>[Sales Amount (YTD)]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'</SPAN><SPAN>dCalendar'[Month]</SPAN><SPAN>&nbsp;=&nbsp;</SPAN><SPAN>vMonth</SPAN><SPAN>)<BR />***************************************************</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Did I solve your problem?<BR />Please mark as solution so others can find this solution.<BR /><A href="https://www.linkedin.com/in/rodrigosanpbi/" target="_blank">https://www.linkedin.com/in/rodrigosanpbi/</A></SPAN></DIV></DIV> Thu, 14 Jul 2022 11:16:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638552#M77421 rodrigosan 2022-07-14T11:16:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638674#M77428 <P>Would you mind attaching the pbix as well?</P> Thu, 14 Jul 2022 12:15:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638674#M77428 Anonymous 2022-07-14T12:15:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638688#M77430 <P>Of course, here's the link:&nbsp;<A href="https://easyupload.io/z0udod" target="_blank">https://easyupload.io/z0udod</A></P><P>This is my test file.<BR />These are fictitious data.<BR /><BR /></P><P>Did I solve your problem?<BR />Please mark as solution so others can find this solution.<BR /><A href="https://www.linkedin.com/in/rodrigosanpbi/" target="_blank">https://www.linkedin.com/in/rodrigosanpbi/</A></P> Thu, 14 Jul 2022 12:25:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-same-period-YTD-across-any-previous-years-in-a-single/m-p/2638688#M77430 rodrigosan 2022-07-14T12:25:15Z