topic Date range dynamicaly in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080279#M107316 <P>I have 3 months data.</P><P>Want monthly MTD dynamicly for current month.&nbsp;</P><P>I want to put start date of available latest month ( obviously 1day) and</P><P>Available last date in date range selection .&nbsp;</P><P>Any one assist me on this dax?&nbsp;</P> Tue, 14 Feb 2023 20:56:39 GMT Anonymous 2023-02-14T20:56:39Z Date range dynamicaly https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080279#M107316 <P>I have 3 months data.</P><P>Want monthly MTD dynamicly for current month.&nbsp;</P><P>I want to put start date of available latest month ( obviously 1day) and</P><P>Available last date in date range selection .&nbsp;</P><P>Any one assist me on this dax?&nbsp;</P> Tue, 14 Feb 2023 20:56:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080279#M107316 Anonymous 2023-02-14T20:56:39Z Re: Date range dynamicaly https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080612#M107347 <P>With the limited example and data provided, I think what you are saying is that there is a filter for the last date?</P><P>&nbsp;</P><P>If so,</P><P>Measure Name =</P><H3><STRONG>Var StartDate = DATE(YEAR(TODAY()), MONTH(TODAY()),1)</STRONG></H3><H3><STRONG>Var EndDate = SELECTEDVALUE( [Assumed Date Table with a Date Field], Default Value (You can use TODAY() )</STRONG></H3><H3><STRONG>RETURN CALCULATE( SUM(of some field), FILTER(ALL(some date field),DATESBETWEEN (</STRONG><STRONG>some date field</STRONG><STRONG>,</STRONG><STRONG>StartDate</STRONG><STRONG>,</STRONG><STRONG>EndDate</STRONG></H3><H3><STRONG>)</STRONG></H3><P>&nbsp;</P> Wed, 15 Feb 2023 02:58:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080612#M107347 BrianConnelly 2023-02-15T02:58:29Z Re: Date range dynamicaly https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080776#M107362 <P><img /></P> Wed, 15 Feb 2023 05:58:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-range-dynamicaly/m-p/3080776#M107362 Anonymous 2023-02-15T05:58:45Z