topic Sum of sales price diff vs previous year in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147480#M112650 <P>Hello,</P><P>I am trying to show the effect that sales price changes have in comparison to the sales of the previous year.</P><P>&nbsp;</P><P>That means: average of sales price per item and customer of shown period - average sales price per item and customer of previous year&nbsp; *&nbsp; quantity sold in shown period.</P><P>&nbsp;</P><P>My measure:&nbsp;</P><DIV><DIV><DIV><SPAN>Price change effect = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Data</SPAN><SPAN>[Item No]</SPAN><SPAN>),</SPAN><SPAN>[Avg sales price PY]</SPAN><SPAN>) =</SPAN><SPAN>BLANK</SPAN><SPAN> () &amp;&amp; </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Data</SPAN><SPAN>[Item No]</SPAN><SPAN>),</SPAN><SPAN>[Avg sales price]</SPAN><SPAN>) &lt;&gt; </SPAN><SPAN>BLANK</SPAN><SPAN> () ,</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Data'</SPAN><SPAN>[Item No]</SPAN><SPAN>),(</SPAN><SPAN>[Avg sales price]</SPAN><SPAN> - </SPAN><SPAN>[Avg sales price PY]</SPAN><SPAN>)*</SPAN><SPAN>[Quantities]</SPAN><SPAN>))</SPAN></DIV></DIV></DIV><P>&nbsp;</P><P>It works fine on line level, but the total is incorrect.&nbsp;</P><P>&nbsp;</P><P>The matrix should look like this (sample of April 2022), but with a correct total:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>The left column shows the item numbers and the customers.&nbsp;</P><P>In the last column I have tried to calculate the price effect, <STRONG>but it does not work on the total sum</STRONG>. I need it to sum up the amounts shown, so the total should be 3.551 and not 7.855.</P><P>&nbsp;</P><P>I have also measures for the average sales prices:</P><DIV><DIV><FONT color="#000080"><SPAN>Avg sales price = </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Tabelle</SPAN><SPAN>[Sales Amount]</SPAN><SPAN>),</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Tabelle</SPAN><SPAN>[Quantity]</SPAN><SPAN>))</SPAN></FONT></DIV><DIV><DIV><DIV><FONT color="#000080"><SPAN>Avg sales price PY = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Avg sales price],</SPAN><SPAN>PREVIOUSYEAR</SPAN><SPAN>(Kalender[Date]))</SPAN></FONT></DIV></DIV></DIV></DIV><P>&nbsp;</P><P>I have prepared a dummy table, since I unfortuntely cannot load a pbix file to a location outside my organisation.&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Posting Date</TD><TD>Customer</TD><TD>Item No</TD><TD>Quantity</TD><TD>Sales Amount</TD></TR><TR><TD>11.01.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>10</TD><TD>14.000</TD></TR><TR><TD>15.01.2021</TD><TD>Dave</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>20.01.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>20</TD><TD>1.980</TD></TR><TR><TD>28.01.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>01.02.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>04.02.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>42</TD><TD>4.158</TD></TR><TR><TD>12.02.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>10</TD><TD>14.000</TD></TR><TR><TD>24.02.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>01.03.2021</TD><TD>Dave</TD><TD>IN-175</TD><TD>30</TD><TD>2.970</TD></TR><TR><TD>02.03.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>22.03.2021</TD><TD>Joe</TD><TD>IN-128</TD><TD>1</TD><TD>834</TD></TR><TR><TD>22.03.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>2</TD><TD>2.200</TD></TR><TR><TD>29.03.2021</TD><TD>Joe</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>29.03.2021</TD><TD>Joe</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>23.04.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>6</TD><TD>5.376</TD></TR><TR><TD>30.04.2021</TD><TD>Dave</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>21.05.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.200</TD></TR><TR><TD>21.05.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>3</TD><TD>297</TD></TR><TR><TD>21.05.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>5.000</TD></TR><TR><TD>18.06.2021</TD><TD>Dave</TD><TD>IN-114</TD><TD>12</TD><TD>10.752</TD></TR><TR><TD>21.06.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>6</TD><TD>594</TD></TR><TR><TD>24.06.2021</TD><TD>Jim</TD><TD>IN-118</TD><TD>6</TD><TD>8.850</TD></TR><TR><TD>28.06.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>5</TD><TD>4.480</TD></TR><TR><TD>28.06.2021</TD><TD>Kate</TD><TD>IN-118</TD><TD>1</TD><TD>1.475</TD></TR><TR><TD>28.06.2021</TD><TD>Kate</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>29.06.2021</TD><TD>Joe</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>12.07.2021</TD><TD>Dave</TD><TD>IN-114</TD><TD>3</TD><TD>2.688</TD></TR><TR><TD>12.07.2021</TD><TD>Dave</TD><TD>IN-153</TD><TD>3</TD><TD>3.084</TD></TR><TR><TD>12.07.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>9</TD><TD>891</TD></TR><TR><TD>14.07.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>2.800</TD></TR><TR><TD>14.07.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>7</TD><TD>693</TD></TR><TR><TD>23.07.2021</TD><TD>Dave</TD><TD>IN-166</TD><TD>1</TD><TD>1.729</TD></TR><TR><TD>23.07.2021</TD><TD>Dave</TD><TD>IN-167</TD><TD>1</TD><TD>2.165</TD></TR><TR><TD>26.07.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>5</TD><TD>4.480</TD></TR><TR><TD>02.08.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>6.500</TD></TR><TR><TD>03.08.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>8</TD><TD>792</TD></TR><TR><TD>10.08.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.200</TD></TR><TR><TD>23.08.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>26.08.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>5</TD><TD>495</TD></TR><TR><TD>09.09.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.200</TD></TR><TR><TD>09.09.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>13.09.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>13.09.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>13.09.2021</TD><TD>Kate</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>28.09.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>6</TD><TD>5.376</TD></TR><TR><TD>04.10.2021</TD><TD>Joe</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>20.10.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>20.10.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>5</TD><TD>7.000</TD></TR><TR><TD>20.10.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>08.11.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>2.800</TD></TR><TR><TD>08.11.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>19.11.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>1</TD><TD>1.400</TD></TR><TR><TD>19.11.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>6</TD><TD>594</TD></TR><TR><TD>06.12.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>6.500</TD></TR><TR><TD>06.12.2021</TD><TD>Joe</TD><TD>IN-153</TD><TD>2</TD><TD>2.056</TD></TR><TR><TD>10.12.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>0</TD><TD>0</TD></TR><TR><TD>13.12.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>1</TD><TD>1.400</TD></TR><TR><TD>13.12.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>9</TD><TD>891</TD></TR><TR><TD>11.01.2022</TD><TD>Dave</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>12.01.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>5</TD><TD>7.500</TD></TR><TR><TD>12.01.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>7</TD><TD>693</TD></TR><TR><TD>21.04.2022</TD><TD>Dave</TD><TD>IN-113</TD><TD>1</TD><TD>1.103</TD></TR><TR><TD>21.01.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.500</TD></TR><TR><TD>21.01.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>25.01.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>1</TD><TD>1.500</TD></TR><TR><TD>25.01.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>28</TD><TD>2.772</TD></TR><TR><TD>31.01.2022</TD><TD>Joe</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>04.04.2022</TD><TD>Drake</TD><TD>IN-171</TD><TD>1</TD><TD>1.386</TD></TR><TR><TD>08.02.2022</TD><TD>Dave</TD><TD>IN-175</TD><TD>30</TD><TD>2.970</TD></TR><TR><TD>17.02.2022</TD><TD>Joe</TD><TD>IN-114</TD><TD>1</TD><TD>896</TD></TR><TR><TD>17.02.2022</TD><TD>Joe</TD><TD>IN-138</TD><TD>2</TD><TD>13.000</TD></TR><TR><TD>24.02.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.500</TD></TR><TR><TD>24.02.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>9</TD><TD>891</TD></TR><TR><TD>09.03.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.500</TD></TR><TR><TD>09.03.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>6</TD><TD>594</TD></TR><TR><TD>16.03.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>3.000</TD></TR><TR><TD>16.03.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>12</TD><TD>1.198</TD></TR><TR><TD>30.03.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>5</TD><TD>7.500</TD></TR><TR><TD>01.04.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>3.000</TD></TR><TR><TD>01.04.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>0</TD><TD>0</TD></TR><TR><TD>05.04.2022</TD><TD>Kate</TD><TD>IN-114</TD><TD>10</TD><TD>8.960</TD></TR><TR><TD>05.04.2022</TD><TD>Kate</TD><TD>IN-118</TD><TD>1</TD><TD>1.475</TD></TR><TR><TD>08.04.2022</TD><TD>Dave</TD><TD>IN-169</TD><TD>4</TD><TD>6.856</TD></TR><TR><TD>11.04.2022</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>7.321</TD></TR><TR><TD>11.04.2022</TD><TD>Joe</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>11.04.2022</TD><TD>Andy</TD><TD>IN-128</TD><TD>1</TD><TD>2.501</TD></TR><TR><TD>11.04.2022</TD><TD>Andy</TD><TD>IN-145</TD><TD>2</TD><TD>1.858</TD></TR><TR><TD>14.04.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>35</TD><TD>3.535</TD></TR></TBODY></TABLE><P>I hope that someone can point me in the rigth direction.&nbsp;</P><P>Thanks for your help.</P> Wed, 22 Mar 2023 14:39:55 GMT Anonymous 2023-03-22T14:39:55Z Sum of sales price diff vs previous year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147480#M112650 <P>Hello,</P><P>I am trying to show the effect that sales price changes have in comparison to the sales of the previous year.</P><P>&nbsp;</P><P>That means: average of sales price per item and customer of shown period - average sales price per item and customer of previous year&nbsp; *&nbsp; quantity sold in shown period.</P><P>&nbsp;</P><P>My measure:&nbsp;</P><DIV><DIV><DIV><SPAN>Price change effect = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Data</SPAN><SPAN>[Item No]</SPAN><SPAN>),</SPAN><SPAN>[Avg sales price PY]</SPAN><SPAN>) =</SPAN><SPAN>BLANK</SPAN><SPAN> () &amp;&amp; </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Data</SPAN><SPAN>[Item No]</SPAN><SPAN>),</SPAN><SPAN>[Avg sales price]</SPAN><SPAN>) &lt;&gt; </SPAN><SPAN>BLANK</SPAN><SPAN> () ,</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Data'</SPAN><SPAN>[Item No]</SPAN><SPAN>),(</SPAN><SPAN>[Avg sales price]</SPAN><SPAN> - </SPAN><SPAN>[Avg sales price PY]</SPAN><SPAN>)*</SPAN><SPAN>[Quantities]</SPAN><SPAN>))</SPAN></DIV></DIV></DIV><P>&nbsp;</P><P>It works fine on line level, but the total is incorrect.&nbsp;</P><P>&nbsp;</P><P>The matrix should look like this (sample of April 2022), but with a correct total:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>The left column shows the item numbers and the customers.&nbsp;</P><P>In the last column I have tried to calculate the price effect, <STRONG>but it does not work on the total sum</STRONG>. I need it to sum up the amounts shown, so the total should be 3.551 and not 7.855.</P><P>&nbsp;</P><P>I have also measures for the average sales prices:</P><DIV><DIV><FONT color="#000080"><SPAN>Avg sales price = </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Tabelle</SPAN><SPAN>[Sales Amount]</SPAN><SPAN>),</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Tabelle</SPAN><SPAN>[Quantity]</SPAN><SPAN>))</SPAN></FONT></DIV><DIV><DIV><DIV><FONT color="#000080"><SPAN>Avg sales price PY = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Avg sales price],</SPAN><SPAN>PREVIOUSYEAR</SPAN><SPAN>(Kalender[Date]))</SPAN></FONT></DIV></DIV></DIV></DIV><P>&nbsp;</P><P>I have prepared a dummy table, since I unfortuntely cannot load a pbix file to a location outside my organisation.&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Posting Date</TD><TD>Customer</TD><TD>Item No</TD><TD>Quantity</TD><TD>Sales Amount</TD></TR><TR><TD>11.01.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>10</TD><TD>14.000</TD></TR><TR><TD>15.01.2021</TD><TD>Dave</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>20.01.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>20</TD><TD>1.980</TD></TR><TR><TD>28.01.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>01.02.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>04.02.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>42</TD><TD>4.158</TD></TR><TR><TD>12.02.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>10</TD><TD>14.000</TD></TR><TR><TD>24.02.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>01.03.2021</TD><TD>Dave</TD><TD>IN-175</TD><TD>30</TD><TD>2.970</TD></TR><TR><TD>02.03.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>22.03.2021</TD><TD>Joe</TD><TD>IN-128</TD><TD>1</TD><TD>834</TD></TR><TR><TD>22.03.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>2</TD><TD>2.200</TD></TR><TR><TD>29.03.2021</TD><TD>Joe</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>29.03.2021</TD><TD>Joe</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>23.04.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>6</TD><TD>5.376</TD></TR><TR><TD>30.04.2021</TD><TD>Dave</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>21.05.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.200</TD></TR><TR><TD>21.05.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>3</TD><TD>297</TD></TR><TR><TD>21.05.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>5.000</TD></TR><TR><TD>18.06.2021</TD><TD>Dave</TD><TD>IN-114</TD><TD>12</TD><TD>10.752</TD></TR><TR><TD>21.06.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>6</TD><TD>594</TD></TR><TR><TD>24.06.2021</TD><TD>Jim</TD><TD>IN-118</TD><TD>6</TD><TD>8.850</TD></TR><TR><TD>28.06.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>5</TD><TD>4.480</TD></TR><TR><TD>28.06.2021</TD><TD>Kate</TD><TD>IN-118</TD><TD>1</TD><TD>1.475</TD></TR><TR><TD>28.06.2021</TD><TD>Kate</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>29.06.2021</TD><TD>Joe</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>12.07.2021</TD><TD>Dave</TD><TD>IN-114</TD><TD>3</TD><TD>2.688</TD></TR><TR><TD>12.07.2021</TD><TD>Dave</TD><TD>IN-153</TD><TD>3</TD><TD>3.084</TD></TR><TR><TD>12.07.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>9</TD><TD>891</TD></TR><TR><TD>14.07.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>2.800</TD></TR><TR><TD>14.07.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>7</TD><TD>693</TD></TR><TR><TD>23.07.2021</TD><TD>Dave</TD><TD>IN-166</TD><TD>1</TD><TD>1.729</TD></TR><TR><TD>23.07.2021</TD><TD>Dave</TD><TD>IN-167</TD><TD>1</TD><TD>2.165</TD></TR><TR><TD>26.07.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>5</TD><TD>4.480</TD></TR><TR><TD>02.08.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>6.500</TD></TR><TR><TD>03.08.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>8</TD><TD>792</TD></TR><TR><TD>10.08.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.200</TD></TR><TR><TD>23.08.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>26.08.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>5</TD><TD>495</TD></TR><TR><TD>09.09.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.200</TD></TR><TR><TD>09.09.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>13.09.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>13.09.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>13.09.2021</TD><TD>Kate</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>28.09.2021</TD><TD>Kate</TD><TD>IN-114</TD><TD>6</TD><TD>5.376</TD></TR><TR><TD>04.10.2021</TD><TD>Joe</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>20.10.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>2</TD><TD>3.428</TD></TR><TR><TD>20.10.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>5</TD><TD>7.000</TD></TR><TR><TD>20.10.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>10</TD><TD>990</TD></TR><TR><TD>08.11.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>2.800</TD></TR><TR><TD>08.11.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>19.11.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>1</TD><TD>1.400</TD></TR><TR><TD>19.11.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>6</TD><TD>594</TD></TR><TR><TD>06.12.2021</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>6.500</TD></TR><TR><TD>06.12.2021</TD><TD>Joe</TD><TD>IN-153</TD><TD>2</TD><TD>2.056</TD></TR><TR><TD>10.12.2021</TD><TD>Dave</TD><TD>IN-169</TD><TD>0</TD><TD>0</TD></TR><TR><TD>13.12.2021</TD><TD>Jim</TD><TD>IN-114</TD><TD>1</TD><TD>1.400</TD></TR><TR><TD>13.12.2021</TD><TD>Jim</TD><TD>IN-175</TD><TD>9</TD><TD>891</TD></TR><TR><TD>11.01.2022</TD><TD>Dave</TD><TD>IN-114</TD><TD>2</TD><TD>1.792</TD></TR><TR><TD>12.01.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>5</TD><TD>7.500</TD></TR><TR><TD>12.01.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>7</TD><TD>693</TD></TR><TR><TD>21.04.2022</TD><TD>Dave</TD><TD>IN-113</TD><TD>1</TD><TD>1.103</TD></TR><TR><TD>21.01.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.500</TD></TR><TR><TD>21.01.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>2</TD><TD>198</TD></TR><TR><TD>25.01.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>1</TD><TD>1.500</TD></TR><TR><TD>25.01.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>28</TD><TD>2.772</TD></TR><TR><TD>31.01.2022</TD><TD>Joe</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>04.04.2022</TD><TD>Drake</TD><TD>IN-171</TD><TD>1</TD><TD>1.386</TD></TR><TR><TD>08.02.2022</TD><TD>Dave</TD><TD>IN-175</TD><TD>30</TD><TD>2.970</TD></TR><TR><TD>17.02.2022</TD><TD>Joe</TD><TD>IN-114</TD><TD>1</TD><TD>896</TD></TR><TR><TD>17.02.2022</TD><TD>Joe</TD><TD>IN-138</TD><TD>2</TD><TD>13.000</TD></TR><TR><TD>24.02.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.500</TD></TR><TR><TD>24.02.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>9</TD><TD>891</TD></TR><TR><TD>09.03.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>3</TD><TD>4.500</TD></TR><TR><TD>09.03.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>6</TD><TD>594</TD></TR><TR><TD>16.03.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>3.000</TD></TR><TR><TD>16.03.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>12</TD><TD>1.198</TD></TR><TR><TD>30.03.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>5</TD><TD>7.500</TD></TR><TR><TD>01.04.2022</TD><TD>Jim</TD><TD>IN-114</TD><TD>2</TD><TD>3.000</TD></TR><TR><TD>01.04.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>0</TD><TD>0</TD></TR><TR><TD>05.04.2022</TD><TD>Kate</TD><TD>IN-114</TD><TD>10</TD><TD>8.960</TD></TR><TR><TD>05.04.2022</TD><TD>Kate</TD><TD>IN-118</TD><TD>1</TD><TD>1.475</TD></TR><TR><TD>08.04.2022</TD><TD>Dave</TD><TD>IN-169</TD><TD>4</TD><TD>6.856</TD></TR><TR><TD>11.04.2022</TD><TD>Joe</TD><TD>IN-138</TD><TD>1</TD><TD>7.321</TD></TR><TR><TD>11.04.2022</TD><TD>Joe</TD><TD>IN-153</TD><TD>1</TD><TD>1.028</TD></TR><TR><TD>11.04.2022</TD><TD>Andy</TD><TD>IN-128</TD><TD>1</TD><TD>2.501</TD></TR><TR><TD>11.04.2022</TD><TD>Andy</TD><TD>IN-145</TD><TD>2</TD><TD>1.858</TD></TR><TR><TD>14.04.2022</TD><TD>Jim</TD><TD>IN-175</TD><TD>35</TD><TD>3.535</TD></TR></TBODY></TABLE><P>I hope that someone can point me in the rigth direction.&nbsp;</P><P>Thanks for your help.</P> Wed, 22 Mar 2023 14:39:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147480#M112650 Anonymous 2023-03-22T14:39:55Z Re: Sum of sales price diff vs previous year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147572#M112661 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>please try</P> <P>Price change effect =<BR />SUMX (<BR />VALUES ( Data[Item No] ),<BR />VAR AvgTY = [Avg sales price]<BR />VAR AvgPY = [Avg sales price PY]<BR />VAR Qty = [Quantities]<BR />RETURN<BR />IF ( AvgPY = BLANK () &amp;&amp; AvgTY &lt;&gt; BLANK (), BLANK (), ( AvgTY - AvgPY ) * Qty )<BR />)</P> Wed, 22 Mar 2023 15:12:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147572#M112661 tamerj1 2023-03-22T15:12:42Z Re: Sum of sales price diff vs previous year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147778#M112675 <P>Super, thanks, that works like a charm! Thanks for sorting out my mess!&nbsp;<span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P> Wed, 22 Mar 2023 16:28:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-sales-price-diff-vs-previous-year/m-p/3147778#M112675 Anonymous 2023-03-22T16:28:48Z