topic Re: Sum total previous date filtered in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-total-previous-date-filtered/m-p/2166251#M50197 <P>I look around documentation and inside forum and i create this result.</P><P>&nbsp;</P><DIV><DIV><SPAN>PreviousBalance = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>MinDate</SPAN><SPAN> = </SPAN><SPAN>CALCULATE</SPAN><SPAN>( </SPAN><SPAN>MIN</SPAN><SPAN>(</SPAN><SPAN>'Public DimDate'[Date]</SPAN><SPAN>), </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'Publico DimDate'[Date]</SPAN><SPAN>) )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>'Account FactAccountingMoviment'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Account FactAccountingMoviment'[CreditValue]</SPAN><SPAN> - </SPAN><SPAN>'Account FactAccountingMoviment'[DebtValue]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>,</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Public DimDate'</SPAN><SPAN>),</SPAN><SPAN>'Public DimDate'[Date]</SPAN><SPAN> &lt; MinDate</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Mon, 01 Nov 2021 12:51:37 GMT RafaelRSantos_ 2021-11-01T12:51:37Z Sum total previous date filtered https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-total-previous-date-filtered/m-p/2163771#M50060 <P>Hi,</P><P>I need help to create a measure to Sum Total Value before the date specified in slice.</P><P>I have a stars chema</P><P><STRONG>FactAccountingMoviment</STRONG></P><P>SkDimDate</P><P>SkDimAccount</P><P>CreditValueMoviment</P><P>DebtValueMoviment</P><P><STRONG>DimDate</STRONG></P><P>SkDimDate</P><P>Date</P><P><STRONG>DimAccount</STRONG></P><P>SkDimAccount</P><P>Account</P><P>&nbsp;</P><P>Follows the desired layout</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Account</TD><TD>Date</TD><TD>Previous Balance</TD><TD>Credit Moviment</TD><TD>Debt Moviment</TD><TD>Period Moviment</TD><TD>Actual Balance</TD></TR><TR><TD>6.0.1.2.3</TD><TD>23/out</TD><TD>100</TD><TD>5</TD><TD>2</TD><TD>3</TD><TD>103</TD></TR><TR><TD>6.0.1.2.3</TD><TD>24/out</TD><TD>103</TD><TD>7</TD><TD>4</TD><TD>3</TD><TD>106</TD></TR><TR><TD>6.0.1.2.3</TD><TD>25/out</TD><TD>106</TD><TD>5</TD><TD>1</TD><TD>4</TD><TD>110</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>I need the previous ballance dax calc</STRONG></P> Fri, 29 Oct 2021 19:56:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-total-previous-date-filtered/m-p/2163771#M50060 RafaelRSantos_ 2021-10-29T19:56:25Z Re: Sum total previous date filtered https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-total-previous-date-filtered/m-p/2166251#M50197 <P>I look around documentation and inside forum and i create this result.</P><P>&nbsp;</P><DIV><DIV><SPAN>PreviousBalance = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>MinDate</SPAN><SPAN> = </SPAN><SPAN>CALCULATE</SPAN><SPAN>( </SPAN><SPAN>MIN</SPAN><SPAN>(</SPAN><SPAN>'Public DimDate'[Date]</SPAN><SPAN>), </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'Publico DimDate'[Date]</SPAN><SPAN>) )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>'Account FactAccountingMoviment'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>'Account FactAccountingMoviment'[CreditValue]</SPAN><SPAN> - </SPAN><SPAN>'Account FactAccountingMoviment'[DebtValue]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>,</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Public DimDate'</SPAN><SPAN>),</SPAN><SPAN>'Public DimDate'[Date]</SPAN><SPAN> &lt; MinDate</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Mon, 01 Nov 2021 12:51:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-total-previous-date-filtered/m-p/2166251#M50197 RafaelRSantos_ 2021-11-01T12:51:37Z