topic Re: DAX Help to For Drawdown in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2760679#M85555 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp; - The expected result is the "Drawdown" row below</P><TABLE><TBODY><TR><TD>ID</TD><TD>WIN STATUS</TD><TD>2017</TD><TD>2018</TD><TD>2019</TD><TD>2020</TD><TD>2021</TD><TD>2022</TD><TD>2023</TD><TD>2024</TD><TD>2025</TD><TD>2026</TD></TR><TR><TD>P01</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P03</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P04</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P05</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$2</TD><TD>$2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P06</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$3</TD><TD>$3</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P07</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P08</TD><TD>NO WIN</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P09</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P10</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P11</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P12</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$10</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P13</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P14</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P15</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P16</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$6</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P17</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P18</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>NO WIN</TD><TD>$5</TD><TD>$25</TD><TD>$15</TD><TD>$5</TD><TD>$20</TD><TD>$40</TD><TD>$20</TD><TD>$5</TD><TD>$0</TD><TD>$0</TD></TR><TR><TD>WIN</TD><TD>$0</TD><TD>$0</TD><TD>$0</TD><TD>$16</TD><TD>$10</TD><TD>$0</TD><TD>$15</TD><TD>$10</TD><TD>$0</TD><TD>$0</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>TOTAL CUMULATIVE</TD><TD>$5</TD><TD>$30</TD><TD>$45</TD><TD>$66</TD><TD>$96</TD><TD>$136</TD><TD>$171</TD><TD>$186</TD><TD>$186</TD><TD>$186</TD></TR><TR><TD>DRAWDOWN</TD><TD>$181</TD><TD>$156</TD><TD>$141</TD><TD>$152</TD><TD>$142</TD><TD>$102</TD><TD>$97</TD><TD>$102</TD><TD>$102</TD><TD>$102</TD></TR></TBODY></TABLE><P><BR /><BR /><BR /></P> Mon, 12 Sep 2022 01:33:14 GMT hackfifi 2022-09-12T01:33:14Z DAX Help to For Drawdown https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2756770#M85255 <DIV>Good Day</DIV><DIV>I am trying to calculate the "Drawdown" row as per the below data table example.<BR />As you can see the TOTAL CUMATIVE Formula used gives the Cumulative by Year resulting in a value of $186</DIV><DIV>&nbsp;</DIV><DIV>I am trying to Acheive the "DrawDown" calculation based on WIN(+) and NO WIN(-) by year</DIV><DIV><STRONG>Hence starting from $186 (Total Budget) - "NO WIN" + "WIN"&nbsp;</STRONG></DIV><DIV><STRONG><BR />So in the below example:</STRONG></DIV><DIV><STRONG>=186-[5+0]-[25+0]-[15+0]-[5+16]-[15+10]-[30+0]-[25+15]-[15+10]</STRONG></DIV><DIV>&nbsp;</DIV><DIV>Hence, i need support to develop the above measure Cumulative Drawdown by Year</DIV><DIV>&nbsp;</DIV><DIV>Thanks!</DIV><DIV>&nbsp;</DIV><DIV><STRONG>Total_Cumulative_Overall =</STRONG></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>[Budget]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'_Calendar'</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><SPAN>ISONORAFTER</SPAN><SPAN>(</SPAN><SPAN>_Calendar</SPAN><SPAN>[Date]</SPAN><SPAN>,&nbsp;</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>_Calendar</SPAN><SPAN>[Date]</SPAN><SPAN>),</SPAN><SPAN>DESC</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )<BR /></SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><img /></SPAN></DIV> Fri, 09 Sep 2022 01:04:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2756770#M85255 hackfifi 2022-09-09T01:04:28Z Re: DAX Help to For Drawdown https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2758250#M85386 <P>Will each P value always only be either Win or No Win? Will that not change over time?</P> <P>&nbsp;</P> <P>Please provide sanitized sample data that fully covers your issue. <A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> I can only help you with meaningful sample data.<BR />Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.<BR /><BR /><BR /></P> Fri, 09 Sep 2022 13:03:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2758250#M85386 lbendlin 2022-09-09T13:03:44Z Re: DAX Help to For Drawdown https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2760679#M85555 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp; - The expected result is the "Drawdown" row below</P><TABLE><TBODY><TR><TD>ID</TD><TD>WIN STATUS</TD><TD>2017</TD><TD>2018</TD><TD>2019</TD><TD>2020</TD><TD>2021</TD><TD>2022</TD><TD>2023</TD><TD>2024</TD><TD>2025</TD><TD>2026</TD></TR><TR><TD>P01</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P03</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P04</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P05</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$2</TD><TD>$2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P06</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$3</TD><TD>$3</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P07</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P08</TD><TD>NO WIN</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P09</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P10</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P11</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P12</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$10</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P13</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P14</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P15</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$5</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P16</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$6</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P17</TD><TD>NO WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$5</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>P18</TD><TD>WIN</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>NO WIN</TD><TD>$5</TD><TD>$25</TD><TD>$15</TD><TD>$5</TD><TD>$20</TD><TD>$40</TD><TD>$20</TD><TD>$5</TD><TD>$0</TD><TD>$0</TD></TR><TR><TD>WIN</TD><TD>$0</TD><TD>$0</TD><TD>$0</TD><TD>$16</TD><TD>$10</TD><TD>$0</TD><TD>$15</TD><TD>$10</TD><TD>$0</TD><TD>$0</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>TOTAL CUMULATIVE</TD><TD>$5</TD><TD>$30</TD><TD>$45</TD><TD>$66</TD><TD>$96</TD><TD>$136</TD><TD>$171</TD><TD>$186</TD><TD>$186</TD><TD>$186</TD></TR><TR><TD>DRAWDOWN</TD><TD>$181</TD><TD>$156</TD><TD>$141</TD><TD>$152</TD><TD>$142</TD><TD>$102</TD><TD>$97</TD><TD>$102</TD><TD>$102</TD><TD>$102</TD></TR></TBODY></TABLE><P><BR /><BR /><BR /></P> Mon, 12 Sep 2022 01:33:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2760679#M85555 hackfifi 2022-09-12T01:33:14Z Re: DAX Help to For Drawdown https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2762438#M85666 <P>I don't pretend to understand the definition of drawdown (despite having read the article multiple times) but here is a solution proposal.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 12 Sep 2022 16:15:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-to-For-Drawdown/m-p/2762438#M85666 lbendlin 2022-09-12T16:15:34Z