topic Re: Inventario horizontal in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3240887#M119240 <P>Thank you, I am sending a copy of the original report, which shows just what I need&nbsp;<A title="Example of horizontal report" href="https://1drv.ms/f/s!AtoX-LNqEm8EgpB-62bGVvSixE4yqg?e=52cN0M" target="_self">File to Example</A>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 May 2023 18:18:10 GMT miguelote 2023-05-17T18:18:10Z Inventario horizontal https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3236275#M118963 <P>Buen día a todos,</P><P>Tengo un problema con una función que se ve fácil pero no he podido solucionarla en DAX, y pido de su ayuda para resolverlo.</P><P>&nbsp;</P><P>Mi problema es el siguiente:</P><P>tengo un inventario a la semana (week_1, fecha actual que es la fecha de actualización) y necesito calcular el estimado para las siguientes semanas (week_2, week_3, week_n), pero para week_1, se resta la cantidad por empaque multiplicado por un 1 (valor dado):</P><P>&nbsp; &nbsp;valor de week_1= Inventario - (cantidad empaque * valor dado)</P><P>&nbsp;</P><P>El problema viene cuando quiero utilizar el valor que obtuve en week_1 con la formula anterior:</P><P>&nbsp; &nbsp;week_2 = week_1 -&nbsp;(cantidad&nbsp;per package * valor dado)</P><P>&nbsp;</P><P>Con esto, quiero ver para las proximas semanas, el valor hasta week_n</P><LI-CODE lang="markup">Week_1 = CALCULATE( AVERAGE(TABLE INVENTORY[INVENTORY]) - ('Takt per week'[Takt per week Value] * AVERAGE(TABLE INVENTORY[QTY_PER_package])) )</LI-CODE><P>Algien me puede ayudar con esto?, mando una pequeña imagen de la tabla y su resultado esperado en formato horizontal</P><P><img /></P><P>&nbsp;</P> Mon, 15 May 2023 18:20:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3236275#M118963 miguelote 2023-05-15T18:20:30Z Re: Inventario horizontal https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3239116#M119129 <P>This should be possible via SUMX.&nbsp;&nbsp;Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). <BR /><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> <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR /><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Wed, 17 May 2023 01:26:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3239116#M119129 lbendlin 2023-05-17T01:26:00Z Re: Inventario horizontal https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3240887#M119240 <P>Thank you, I am sending a copy of the original report, which shows just what I need&nbsp;<A title="Example of horizontal report" href="https://1drv.ms/f/s!AtoX-LNqEm8EgpB-62bGVvSixE4yqg?e=52cN0M" target="_self">File to Example</A>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 May 2023 18:18:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3240887#M119240 miguelote 2023-05-17T18:18:10Z Re: Inventario horizontal https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3240896#M119242 <TABLE border="1"><TBODY><TR><TD><STRONG>Component Part</STRONG></TD><TD><STRONG>Qty per Assembly</STRONG></TD><TD><STRONG>Safety Stock</STRONG></TD><TD><STRONG>Quantity On Hand</STRONG></TD><TD><STRONG>RC</STRONG></TD><TD><STRONG>Total Inventory</STRONG></TD><TD><STRONG>WK15</STRONG></TD><TD><STRONG>WK16</STRONG></TD><TD><STRONG>WK17</STRONG></TD><TD><STRONG>WK18</STRONG></TD></TR><TR><TD>sku1</TD><TD>1</TD><TD>20</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-1</TD><TD>-2</TD><TD>-3</TD><TD>-4</TD></TR><TR><TD>sku2</TD><TD>1</TD><TD>8</TD><TD>62</TD><TD>0</TD><TD>62</TD><TD>61</TD><TD>60</TD><TD>59</TD><TD>58</TD></TR><TR><TD>sku3</TD><TD>1</TD><TD>18</TD><TD>11</TD><TD>28</TD><TD>39</TD><TD>38</TD><TD>37</TD><TD>36</TD><TD>35</TD></TR><TR><TD>sku4</TD><TD>1</TD><TD>0</TD><TD>16</TD><TD>0</TD><TD>16</TD><TD>15</TD><TD>14</TD><TD>13</TD><TD>12</TD></TR></TBODY></TABLE> Wed, 17 May 2023 18:27:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Inventario-horizontal/m-p/3240896#M119242 miguelote 2023-05-17T18:27:10Z