topic Re: Need Help in calculated column in Developer https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4048092#M54227 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/751853">@heetu24</a>&nbsp;,</P> <P>&nbsp;</P> <P>You might consider using the following dax</P> <LI-CODE lang="markup">Test = var _current= SUMX( FILTER(ALL('Table'),'Table'[Period]="Current Year"),[Sales Value]) var _last= SUMX( FILTER(ALL('Table'),'Table'[Period]="Last Year"),[Sales Value]) var _value= _current - _last * 10000 return IF( 'Table'[Product ID]=MINX(ALL('Table'),[Product ID]),_value,BLANK())</LI-CODE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_0-1722331527488.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1141545iDD3554259CB0C343/image-size/large?v=v2&amp;px=999" role="button" title="vyangliumsft_0-1722331527488.png" alt="vyangliumsft_0-1722331527488.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly.</P> Tue, 30 Jul 2024 09:25:49 GMT Anonymous 2024-07-30T09:25:49Z Need Help in calculated column https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4044540#M54207 <P>Hello All,<BR /><BR />I want to calculate the BPS(Basis Points) by creating new calculated column&nbsp; in Power BI Desktop using DAX.<BR /><BR />Formula = Current Year sales - last Year sales *10000<BR /><BR />Sample data&nbsp; is below. Can some one assist?</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Country</TD><TD>Product ID</TD><TD>Time Group</TD><TD>Company</TD><TD>Price Tier</TD><TD>Period</TD><TD>Sales Value</TD></TR><TR><TD>IND</TD><TD>1</TD><TD>MAT</TD><TD>A</TD><TD>Economy</TD><TD>Current Year</TD><TD>589</TD></TR><TR><TD>CHN</TD><TD>2</TD><TD>MAT</TD><TD>B</TD><TD>Premium</TD><TD>Last Year</TD><TD>548</TD></TR><TR><TD>CAN</TD><TD>3</TD><TD>MAT</TD><TD>C</TD><TD>Super Premium</TD><TD>Last two Year</TD><TD>256</TD></TR><TR><TD>NA</TD><TD>4</TD><TD>YTD</TD><TD>k</TD><TD>Economy</TD><TD>Current Year</TD><TD>564</TD></TR><TR><TD>SA</TD><TD>5</TD><TD>YTD</TD><TD>J</TD><TD>Premium</TD><TD>Last Year</TD><TD>256</TD></TR><TR><TD>SRI LANKA</TD><TD>6</TD><TD>YTD</TD><TD>H</TD><TD>Super Premium</TD><TD>Last two Year</TD><TD>845</TD></TR></TBODY></TABLE><P><BR /><BR /></P> Tue, 16 Jul 2024 15:16:54 GMT https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4044540#M54207 heetu24 2024-07-16T15:16:54Z Re: Need Help in calculated column https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4045062#M54210 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/751853">@heetu24</a>&nbsp;,</P> <P>&nbsp;</P> <P>Here are the steps you can follow：</P> <P>1. Create calculated column.</P> <P>&nbsp;</P> <LI-CODE lang="markup">Test = var _current= SUMX( FILTER(ALL('Table'),'Table'[Period]="Current Year"),[Sales Value]) var _last= SUMX( FILTER(ALL('Table'),'Table'[Period]="Last Year"),[Sales Value]) return _current - _last * 10000</LI-CODE> <P>&nbsp;</P> <P>2. Result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_0-1721178355157.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1133361i62DEEE2BDEF80A60/image-size/large?v=v2&amp;px=999" role="button" title="vyangliumsft_0-1721178355157.png" alt="vyangliumsft_0-1721178355157.png" /></span></P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly</P> Wed, 17 Jul 2024 01:07:19 GMT https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4045062#M54210 Anonymous 2024-07-17T01:07:19Z Re: Need Help in calculated column https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4047781#M54224 <P>It is coming same value in each record I am looking separate value&nbsp;</P> Thu, 18 Jul 2024 07:02:53 GMT https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4047781#M54224 heetu24 2024-07-18T07:02:53Z Re: Need Help in calculated column https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4048092#M54227 <P>Hi&nbsp; <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/751853">@heetu24</a>&nbsp;,</P> <P>&nbsp;</P> <P>You might consider using the following dax</P> <LI-CODE lang="markup">Test = var _current= SUMX( FILTER(ALL('Table'),'Table'[Period]="Current Year"),[Sales Value]) var _last= SUMX( FILTER(ALL('Table'),'Table'[Period]="Last Year"),[Sales Value]) var _value= _current - _last * 10000 return IF( 'Table'[Product ID]=MINX(ALL('Table'),[Product ID]),_value,BLANK())</LI-CODE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyangliumsft_0-1722331527488.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1141545iDD3554259CB0C343/image-size/large?v=v2&amp;px=999" role="button" title="vyangliumsft_0-1722331527488.png" alt="vyangliumsft_0-1722331527488.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Liu Yang</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM>Accept it as the solution</EM> to help the other members find it more quickly.</P> Tue, 30 Jul 2024 09:25:49 GMT https://community.fabric.microsoft.com/t5/Developer/Need-Help-in-calculated-column/m-p/4048092#M54227 Anonymous 2024-07-30T09:25:49Z