topic Re: Dax future time period in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2963018#M98777 <P>A rolling time period would be helpful too!</P> Mon, 12 Dec 2022 16:10:53 GMT Anonymous 2022-12-12T16:10:53Z Dax future time period https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2960577#M98570 <P>Working with time periods, I have what I want for the past, but how can I add in future? Looking for Next 90 days, etc<BR />Current dax</P><DIV><DIV>&nbsp;</DIV><DIV><SPAN>Time Periods = </SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>_today</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>MAX</SPAN><SPAN> ( </SPAN><SPAN>'Date Refresh'</SPAN><SPAN>[Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>_thisyear</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>YEAR</SPAN><SPAN> ( </SPAN><SPAN>_today</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>_thismonth</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>MONTH</SPAN><SPAN> ( </SPAN><SPAN>_today</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>_thisday</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>DAY</SPAN><SPAN> ( </SPAN><SPAN>_today</SPAN><SPAN> )</SPAN></DIV><DIV><SPAN>return</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SELECTCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>UNION</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>//Yesterday</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SELECTCOLUMNS</SPAN><SPAN>( {</SPAN><SPAN>"Yesterday"</SPAN><SPAN>}, </SPAN><SPAN>"Period"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>_thisyear</SPAN><SPAN>, </SPAN><SPAN>_thismonth</SPAN><SPAN>, </SPAN><SPAN>_thisday</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN>), </SPAN><SPAN>_today</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Axis Date"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>//Last30Days</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SELECTCOLUMNS</SPAN><SPAN>( {</SPAN><SPAN>"Last 30 Days"</SPAN><SPAN>}, </SPAN><SPAN>"Period"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>_thisyear</SPAN><SPAN>, </SPAN><SPAN>_thismonth</SPAN><SPAN>, </SPAN><SPAN>_thisday</SPAN><SPAN> -</SPAN><SPAN>30</SPAN><SPAN>), </SPAN><SPAN>_today</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Axis Date"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>//Last60Days</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SELECTCOLUMNS</SPAN><SPAN>( {</SPAN><SPAN>"Last 60 Days"</SPAN><SPAN>}, </SPAN><SPAN>"Period"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>_thisyear</SPAN><SPAN>, </SPAN><SPAN>_thismonth</SPAN><SPAN>, </SPAN><SPAN>_thisday</SPAN><SPAN> -</SPAN><SPAN>60</SPAN><SPAN>), </SPAN><SPAN>_today</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Axis Date"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>//Last90Days</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SELECTCOLUMNS</SPAN><SPAN>( {</SPAN><SPAN>"Last 90 Days"</SPAN><SPAN>}, </SPAN><SPAN>"Period"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>_thisyear</SPAN><SPAN>, </SPAN><SPAN>_thismonth</SPAN><SPAN>, </SPAN><SPAN>_thisday</SPAN><SPAN> -</SPAN><SPAN>90</SPAN><SPAN>), </SPAN><SPAN>_today</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Axis Date"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>//LastMonth</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SELECTCOLUMNS</SPAN><SPAN>( {</SPAN><SPAN>"Last Month"</SPAN><SPAN>}, </SPAN><SPAN>"Period"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN> (</SPAN><SPAN>_thisyear</SPAN><SPAN>, </SPAN><SPAN>_thismonth</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>), </SPAN><SPAN>EOMONTH</SPAN><SPAN>( </SPAN><SPAN>_today</SPAN><SPAN>,-</SPAN><SPAN>1</SPAN><SPAN>) )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Axis Date"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Date"</SPAN><SPAN>, </SPAN><SPAN>[Value]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Period"</SPAN><SPAN>, </SPAN><SPAN>[Period]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Axis Date"</SPAN><SPAN>, </SPAN><SPAN>[Axis Date]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV></DIV> Sat, 10 Dec 2022 23:22:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2960577#M98570 Anonymous 2022-12-10T23:22:27Z Re: Dax future time period https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2960847#M98601 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>would you please asvise the expected result of this table?</P> Sun, 11 Dec 2022 15:20:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2960847#M98601 tamerj1 2022-12-11T15:20:05Z Re: Dax future time period https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2963015#M98776 <P>The dax above is working as intended. Ideally I would like to be able to add to this dax to also get a selection in the column for the next 90 days, next 6 months, and next year. In our business we enter orders in to our ERP and alot of our business is in the future, so this would help us with projecting for time periods. Thanks!</P> Mon, 12 Dec 2022 16:10:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2963015#M98776 Anonymous 2022-12-12T16:10:06Z Re: Dax future time period https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2963018#M98777 <P>A rolling time period would be helpful too!</P> Mon, 12 Dec 2022 16:10:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-future-time-period/m-p/2963018#M98777 Anonymous 2022-12-12T16:10:53Z