topic Re: Sum for top dates in table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134466#M48987 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="54234" data-lia-user-login="Raaassotto" class="lia-mention lia-mention-user">Raaassotto</a>&nbsp;,</P><P>&nbsp;</P><P>You can try this measure:</P><DIV><DIV><SPAN>Sales 2 = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'Table'[Sales,$]</SPAN><SPAN>),</SPAN><SPAN>TOPN</SPAN><SPAN>(</SPAN><SPAN>3</SPAN><SPAN>,</SPAN><SPAN>'Table'</SPAN><SPAN>,</SPAN><SPAN>'Table'[Date]</SPAN><SPAN>,</SPAN><SPAN>DESC</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Result:</SPAN></DIV><DIV><img /><P>&nbsp;</P><P>Jori</P><P>&nbsp;</P><P><EM><STRONG>If I answered your question, please mark it as a solution to help other members find it more quickly.<STRONG><EM><BR /></EM></STRONG></STRONG></EM><BR /><A href="https://www.linkedin.com/in/joripallada/" target="_blank">Connect on Linkedin</A></P></DIV></DIV> Thu, 14 Oct 2021 08:51:41 GMT jppv20 2021-10-14T08:51:41Z Sum for top dates in table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134462#M48986 <P>Please help to make a dax function to sum sales for the top latest 3 dates. For every seller latest dates could be different.&nbsp;</P><TABLE><TBODY><TR><TD>Seller</TD><TD>Date</TD><TD>Sales,$</TD></TR><TR><TD>John</TD><TD>01.02.2021</TD><TD>50000</TD></TR><TR><TD>John</TD><TD>02.02.2021</TD><TD>20000</TD></TR><TR><TD><FONT color="#FF0000">John</FONT></TD><TD><FONT color="#FF0000">03.02.2021</FONT></TD><TD><FONT color="#FF0000">35000</FONT></TD></TR><TR><TD><FONT color="#FF0000">John</FONT></TD><TD><FONT color="#FF0000">04.02.2021</FONT></TD><TD><FONT color="#FF0000">65000</FONT></TD></TR><TR><TD><FONT color="#FF0000">John</FONT></TD><TD><FONT color="#FF0000">05.02.2021</FONT></TD><TD><FONT color="#FF0000">25000</FONT></TD></TR></TBODY></TABLE> Thu, 14 Oct 2021 08:45:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134462#M48986 Raaassotto 2021-10-14T08:45:39Z Re: Sum for top dates in table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134466#M48987 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="54234" data-lia-user-login="Raaassotto" class="lia-mention lia-mention-user">Raaassotto</a>&nbsp;,</P><P>&nbsp;</P><P>You can try this measure:</P><DIV><DIV><SPAN>Sales 2 = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'Table'[Sales,$]</SPAN><SPAN>),</SPAN><SPAN>TOPN</SPAN><SPAN>(</SPAN><SPAN>3</SPAN><SPAN>,</SPAN><SPAN>'Table'</SPAN><SPAN>,</SPAN><SPAN>'Table'[Date]</SPAN><SPAN>,</SPAN><SPAN>DESC</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Result:</SPAN></DIV><DIV><img /><P>&nbsp;</P><P>Jori</P><P>&nbsp;</P><P><EM><STRONG>If I answered your question, please mark it as a solution to help other members find it more quickly.<STRONG><EM><BR /></EM></STRONG></STRONG></EM><BR /><A href="https://www.linkedin.com/in/joripallada/" target="_blank">Connect on Linkedin</A></P></DIV></DIV> Thu, 14 Oct 2021 08:51:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134466#M48987 jppv20 2021-10-14T08:51:41Z Re: Sum for top dates in table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134485#M48990 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="262173" data-lia-user-login="jppv20" class="lia-mention lia-mention-user">jppv20</a>&nbsp;it works! thanks!</P> Thu, 14 Oct 2021 09:03:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-for-top-dates-in-table/m-p/2134485#M48990 Raaassotto 2021-10-14T09:03:01Z