topic Re: Simple calculation in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-calculation/m-p/2945313#M97402 <DIV><DIV><SPAN>I figured out:</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Increase Selceted Day YTD = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>=</SPAN><SPAN>0</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[YTD Selected Day Actual Amount]</SPAN><SPAN>, &nbsp; &nbsp; </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>((</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[YTD Selected Day Actual Amount]</SPAN><SPAN>-</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>)/</SPAN><SPAN>ABS</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>BLANK</SPAN><SPAN>()</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV></DIV> Fri, 02 Dec 2022 18:59:25 GMT Anonymous 2022-12-02T18:59:25Z Simple calculation https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-calculation/m-p/2945303#M97400 <DIV><DIV><SPAN>Hi all,</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I am calculate a simple increase rate: (YTD amount-Prior YTD amount)/Prior YTD amount</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The measure is as follow:</SPAN></DIV><DIV><SPAN>Increase Selceted Day YTD = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD amount]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD amount]</SPAN><SPAN>=</SPAN><SPAN>0</SPAN><SPAN>,<BR /></SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Shop Account Ledger'</SPAN><SPAN>[YTD amount]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>((</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[YTD amount]</SPAN><SPAN>-</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD amount]</SPAN><SPAN>)/</SPAN><SPAN>ABS</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD amount]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;),</SPAN><SPAN>BLANK</SPAN><SPAN>()</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>However, when the denominator(<SPAN>Prior YTD amount</SPAN>) =0, the increase rate is blank, why?</DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P><P>&nbsp;</P><P>Thank you!</P><P>Branko</P></DIV></DIV> Fri, 02 Dec 2022 18:55:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-calculation/m-p/2945303#M97400 Anonymous 2022-12-02T18:55:45Z Re: Simple calculation https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-calculation/m-p/2945313#M97402 <DIV><DIV><SPAN>I figured out:</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Increase Selceted Day YTD = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>=</SPAN><SPAN>0</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[YTD Selected Day Actual Amount]</SPAN><SPAN>, &nbsp; &nbsp; </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>((</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[YTD Selected Day Actual Amount]</SPAN><SPAN>-</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>)/</SPAN><SPAN>ABS</SPAN><SPAN>(</SPAN><SPAN>'Shop Account Ledger'</SPAN><SPAN>[Prior YTD Selected Day Actual Amount]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>BLANK</SPAN><SPAN>()</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV></DIV> Fri, 02 Dec 2022 18:59:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-calculation/m-p/2945313#M97402 Anonymous 2022-12-02T18:59:25Z