https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993787#M100801 <P>From the same table</P> Thu, 29 Dec 2022 18:03:25 GMT AlexFelipe 2022-12-29T18:03:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993550#M100774 <P><img />I wanna show in table only the lastest stage from each name based in date.</P><P>I tried use MAXX function but i failed.</P><P>How can i make it? Thanks everyone</P> Thu, 29 Dec 2022 15:01:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993550#M100774 AlexFelipe 2022-12-29T15:01:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993583#M100778 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="492319" data-lia-user-login="AlexFelipe" class="lia-mention lia-mention-user">AlexFelipe</a>&nbsp;</P> <P>&nbsp;</P> <P>Please create a new measure and add the following formula:</P> <LI-CODE lang="php">MaxStage = CALCULATE(MAX(Sheet1[Stage]),FILTER(Sheet1,Sheet1[Date]=MAX(Sheet1[Date])))</LI-CODE> <P>&nbsp;</P> <P>PowerBI workspace attached</P> <P>&nbsp;</P> Thu, 29 Dec 2022 15:26:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993583#M100778 themistoklis 2022-12-29T15:26:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993621#M100781 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="492319" data-lia-user-login="AlexFelipe" class="lia-mention lia-mention-user">AlexFelipe</a>&nbsp;</P> <P>is the Date column form the same table or from a date table?</P> Thu, 29 Dec 2022 15:42:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993621#M100781 tamerj1 2022-12-29T15:42:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993787#M100801 <P>From the same table</P> Thu, 29 Dec 2022 18:03:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993787#M100801 AlexFelipe 2022-12-29T18:03:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993793#M100803 <P>Works! Thank you so much!!</P><P>I'll just leave the code here for everyone:</P><P>&nbsp;</P><DIV><DIV><SPAN>MaxDate = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>Sheet1</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>Sheet1</SPAN><SPAN>,</SPAN><SPAN>Sheet1</SPAN><SPAN>[Date]</SPAN><SPAN>=</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>Sheet1</SPAN><SPAN>[Date]</SPAN><SPAN>)))</SPAN></DIV><DIV><DIV><DIV><SPAN>MaxStage = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>Sheet1</SPAN><SPAN>[Stage]</SPAN><SPAN>),</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>Sheet1</SPAN><SPAN>,</SPAN><SPAN>Sheet1</SPAN><SPAN>[Date]</SPAN><SPAN>=</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>Sheet1</SPAN><SPAN>[Date]</SPAN><SPAN>)))</SPAN></DIV></DIV></DIV></DIV> Thu, 29 Dec 2022 18:11:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-table-with-lastest-stage-from-each-name-based-in/m-p/2993793#M100803 AlexFelipe 2022-12-29T18:11:36Z