https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Inventory-SUM-for-the-last-day-with-data-of-each-Month/m-p/3458399#M131852 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="572444" data-lia-user-login="Igotzepowerbi" class="lia-mention lia-mention-user">Igotzepowerbi</a>&nbsp;You could create a complex selector like the following:</P> <LI-CODE lang="markup">Selector Measure = VAR __Year = MAX('Table'[Year]) VAR __Month = MAX('Table'[Month]) VAR __Date = MAX('Table'[Date]) VAR __MaxDate = MAXX( DISTINCT( SELECTCOLUMNS( FILTER(ALLSELECTED('Table'), [Year] = __Year &amp;&amp; [Month] = __Month), "Date", [Date]) ), [Date]) VAR __Result = IF(__Date = __MaxDate, 1, 0) RETURN __Result</LI-CODE> <P>You could also create a measure with similar logic that only returns a value if it is the max date.</P> <P>&nbsp;</P> Tue, 03 Oct 2023 22:17:36 GMT Greg_Deckler 2023-10-03T22:17:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Inventory-SUM-for-the-last-day-with-data-of-each-Month/m-p/3458388#M131851 <P>Hi,<BR />I am needing a measure that grabs the last day of the month where there is data and just give me the inventory units for that day.<BR />So I was able to do this with a matrix but I only want the rows highlighted.<BR />Could someone help me?&nbsp;<BR /><BR /></P><P><img /></P><P><img /></P><P>&nbsp;</P> Tue, 03 Oct 2023 22:07:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Inventory-SUM-for-the-last-day-with-data-of-each-Month/m-p/3458388#M131851 Igotzepowerbi 2023-10-03T22:07:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Inventory-SUM-for-the-last-day-with-data-of-each-Month/m-p/3458399#M131852 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="572444" data-lia-user-login="Igotzepowerbi" class="lia-mention lia-mention-user">Igotzepowerbi</a>&nbsp;You could create a complex selector like the following:</P> <LI-CODE lang="markup">Selector Measure = VAR __Year = MAX('Table'[Year]) VAR __Month = MAX('Table'[Month]) VAR __Date = MAX('Table'[Date]) VAR __MaxDate = MAXX( DISTINCT( SELECTCOLUMNS( FILTER(ALLSELECTED('Table'), [Year] = __Year &amp;&amp; [Month] = __Month), "Date", [Date]) ), [Date]) VAR __Result = IF(__Date = __MaxDate, 1, 0) RETURN __Result</LI-CODE> <P>You could also create a measure with similar logic that only returns a value if it is the max date.</P> <P>&nbsp;</P> Tue, 03 Oct 2023 22:17:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Inventory-SUM-for-the-last-day-with-data-of-each-Month/m-p/3458399#M131852 Greg_Deckler 2023-10-03T22:17:36Z