https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MAX-Date-of-what-user-selected/m-p/3850830#M150470 <P>Anonymous</LI-USER>&nbsp;MAXX(ALLSELECTED('Dates'), [Date])</P> Thu, 18 Apr 2024 18:27:43 GMT Greg_Deckler 2024-04-18T18:27:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MAX-Date-of-what-user-selected/m-p/3850815#M150468 <P>Hi, I have a date table with Date, Year, Month, Year-Month, Year-Month-Name.<BR /><BR />My report has a visual where the user can select a Year and another where they can select Multiple Months.<BR /><BR />If the user selects 2024 and then Jan, Feb, March and April I need the following:<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Year-Month-Name</TD><TD>MyMaxDate</TD><TD>MyMaxMonthName</TD></TR><TR><TD>Jan 2024</TD><TD>Apr 30, 2024</TD><TD>Apr, 2024</TD></TR><TR><TD>Feb 2024</TD><TD>Apr 30, 2024</TD><TD>Apr, 2024</TD></TR><TR><TD>March 2024</TD><TD>Apr 30, 2024</TD><TD>Apr, 2024</TD></TR><TR><TD>April 2024</TD><TD>Apr 30, 2024</TD><TD>Apr, 2024</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Note: My Date table has a record for every day from<BR /><BR />1/1/2017 all the way to 12/31/2024</P> Thu, 18 Apr 2024 18:16:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MAX-Date-of-what-user-selected/m-p/3850815#M150468 Anonymous 2024-04-18T18:16:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MAX-Date-of-what-user-selected/m-p/3850830#M150470 <P>Anonymous</LI-USER>&nbsp;MAXX(ALLSELECTED('Dates'), [Date])</P> Thu, 18 Apr 2024 18:27:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MAX-Date-of-what-user-selected/m-p/3850830#M150470 Greg_Deckler 2024-04-18T18:27:43Z