topic Calculated table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-table/m-p/3142948#M112286 <P>Hi everyone, i have the following calculated table</P><DIV><DIV><SPAN>TablaSemestres = </SPAN></DIV><DIV><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2000</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2025</SPAN><SPAN>, </SPAN><SPAN>12</SPAN><SPAN>, </SPAN><SPAN>31</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>183</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Fecha de compra"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>YEAR</SPAN><SPAN>([Value]), </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>([Value]) &lt;= </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>7</SPAN><SPAN>), </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Fecha de venta"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EOMONTH</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>YEAR</SPAN><SPAN>([Value]), </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>([Value]) &lt;= </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>12</SPAN><SPAN>), </SPAN><SPAN>1</SPAN><SPAN>), </SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>And the following calculated column</SPAN></DIV><DIV><DIV><DIV><SPAN>Stock = </SPAN></DIV><DIV><SPAN>-- CONTAR AUTOS COMPRADOS ANTES DE LA FECHA DE COMPRA Y VENDIDOS DESPUES DE LA FECHA DE VENTA (O QUE FECHA DE VENTA ESTÉ EN BLANCO),</SPAN></DIV><DIV><SPAN>-- ES DECIR, COMPRADOS VENDIDOS + COMPRADOS SIN VENDER,</SPAN></DIV><DIV><SPAN>-- QUE NO SEAN FLOTA NI OBSOLETA</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>buydate</SPAN><SPAN> = </SPAN><SPAN>TablaSemestres</SPAN><SPAN>[Fecha de compra]</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>selldate</SPAN><SPAN> = </SPAN><SPAN>TablaSemestres</SPAN><SPAN>[Fecha de venta]</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>stock</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>AUTOS</SPAN><SPAN>[AT_COAUTO]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>AUTOS</SPAN><SPAN>[FECHA COMPRA]</SPAN><SPAN> &lt;= </SPAN><SPAN>buydate</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &amp;&amp;</SPAN><SPAN>AUTOS</SPAN><SPAN>[Fecha Reserva]</SPAN><SPAN> &gt;= </SPAN><SPAN>selldate</SPAN><SPAN> || </SPAN><SPAN>AUTOS</SPAN><SPAN>[Fecha Reserva]</SPAN><SPAN> = </SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CLAAUTOS</SPAN><SPAN>[CLAU_DETALLE]</SPAN><SPAN> &lt;&gt; </SPAN><SPAN>"FLOTA"</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>CLAAUTOS</SPAN><SPAN>[CLAU_DETALLE]</SPAN><SPAN> &lt;&gt; </SPAN><SPAN>"OBSOLETA"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>TablaSemestres</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>return</SPAN> <SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>TablaSemestres</SPAN><SPAN>[Value]</SPAN><SPAN> &gt; </SPAN><SPAN>TODAY</SPAN><SPAN>(), </SPAN><SPAN>0</SPAN><SPAN>, </SPAN><SPAN>stock</SPAN><SPAN>)</SPAN></DIV><DIV><img /><P>&nbsp;</P></DIV><DIV><SPAN>I want to add a new column in the calculated table with the different cities of the table (AUTOS) to get the stock of every city each semester. Can someone help me ?</SPAN></DIV></DIV></DIV></DIV> Mon, 20 Mar 2023 16:42:55 GMT feralvarez994 2023-03-20T16:42:55Z Calculated table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-table/m-p/3142948#M112286 <P>Hi everyone, i have the following calculated table</P><DIV><DIV><SPAN>TablaSemestres = </SPAN></DIV><DIV><SPAN>ADDCOLUMNS</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>GENERATESERIES</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2000</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>2025</SPAN><SPAN>, </SPAN><SPAN>12</SPAN><SPAN>, </SPAN><SPAN>31</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>183</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Fecha de compra"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>YEAR</SPAN><SPAN>([Value]), </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>([Value]) &lt;= </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>7</SPAN><SPAN>), </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Fecha de venta"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EOMONTH</SPAN><SPAN>(</SPAN><SPAN>DATE</SPAN><SPAN>(</SPAN><SPAN>YEAR</SPAN><SPAN>([Value]), </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>MONTH</SPAN><SPAN>([Value]) &lt;= </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>6</SPAN><SPAN>, </SPAN><SPAN>12</SPAN><SPAN>), </SPAN><SPAN>1</SPAN><SPAN>), </SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>And the following calculated column</SPAN></DIV><DIV><DIV><DIV><SPAN>Stock = </SPAN></DIV><DIV><SPAN>-- CONTAR AUTOS COMPRADOS ANTES DE LA FECHA DE COMPRA Y VENDIDOS DESPUES DE LA FECHA DE VENTA (O QUE FECHA DE VENTA ESTÉ EN BLANCO),</SPAN></DIV><DIV><SPAN>-- ES DECIR, COMPRADOS VENDIDOS + COMPRADOS SIN VENDER,</SPAN></DIV><DIV><SPAN>-- QUE NO SEAN FLOTA NI OBSOLETA</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>buydate</SPAN><SPAN> = </SPAN><SPAN>TablaSemestres</SPAN><SPAN>[Fecha de compra]</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>selldate</SPAN><SPAN> = </SPAN><SPAN>TablaSemestres</SPAN><SPAN>[Fecha de venta]</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>stock</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>AUTOS</SPAN><SPAN>[AT_COAUTO]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>AUTOS</SPAN><SPAN>[FECHA COMPRA]</SPAN><SPAN> &lt;= </SPAN><SPAN>buydate</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &amp;&amp;</SPAN><SPAN>AUTOS</SPAN><SPAN>[Fecha Reserva]</SPAN><SPAN> &gt;= </SPAN><SPAN>selldate</SPAN><SPAN> || </SPAN><SPAN>AUTOS</SPAN><SPAN>[Fecha Reserva]</SPAN><SPAN> = </SPAN><SPAN>BLANK</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CLAAUTOS</SPAN><SPAN>[CLAU_DETALLE]</SPAN><SPAN> &lt;&gt; </SPAN><SPAN>"FLOTA"</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>CLAAUTOS</SPAN><SPAN>[CLAU_DETALLE]</SPAN><SPAN> &lt;&gt; </SPAN><SPAN>"OBSOLETA"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>TablaSemestres</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>return</SPAN> <SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>TablaSemestres</SPAN><SPAN>[Value]</SPAN><SPAN> &gt; </SPAN><SPAN>TODAY</SPAN><SPAN>(), </SPAN><SPAN>0</SPAN><SPAN>, </SPAN><SPAN>stock</SPAN><SPAN>)</SPAN></DIV><DIV><img /><P>&nbsp;</P></DIV><DIV><SPAN>I want to add a new column in the calculated table with the different cities of the table (AUTOS) to get the stock of every city each semester. Can someone help me ?</SPAN></DIV></DIV></DIV></DIV> Mon, 20 Mar 2023 16:42:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-table/m-p/3142948#M112286 feralvarez994 2023-03-20T16:42:55Z Re: Calculated table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-table/m-p/3146016#M112541 <P>Instead of GENERATESERIES use a proper calendar table that includes a semester/half year column.</P> Wed, 22 Mar 2023 00:32:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-table/m-p/3146016#M112541 lbendlin 2023-03-22T00:32:44Z