https://community.fabric.microsoft.com/t5/Developer/C%C3%B3mo-combinar-filas-duplicadas-y-sumar-sus-valores/m-p/3448355#M44686 <P>Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue. <BR />If you are unsure how to do that please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.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 />If you want to get answers faster please refer to <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Tue, 26 Sep 2023 17:40:48 GMT lbendlin 2023-09-26T17:40:48Z https://community.fabric.microsoft.com/t5/Developer/C%C3%B3mo-combinar-filas-duplicadas-y-sumar-sus-valores/m-p/3446831#M44665 <P>Buenas! Tengo en mi tabla , las ventas por producto, cada producto con su valor, y tengo otra columna llamada "Ajuste" que puede sumar o restar un valor al total de la venta. Cuando intento sumar ambas columnas. me esta duplicando el valor de "Ajuste" la cantidad de veces que tenga productos.&nbsp;</P><P>Como veran en la imagen la Suma deberia ser de 50k, pero sumando Venta USD + Ajuste me da 59k ya que me suma 2 veces el valor de Ajuste, cuando solo deberia sumarlo 1 vez sola.&nbsp;</P><P>Se les ocurre alguna forma de solucionarlo???</P><P>Mil gracias!!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JuanMaFre_0-1695685960113.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/973230i74E640A8A95FDD3E/image-size/medium?v=v2&amp;px=400" role="button" title="JuanMaFre_0-1695685960113.png" alt="JuanMaFre_0-1695685960113.png" /></span></P><P>&nbsp;</P> Mon, 25 Sep 2023 23:54:20 GMT https://community.fabric.microsoft.com/t5/Developer/C%C3%B3mo-combinar-filas-duplicadas-y-sumar-sus-valores/m-p/3446831#M44665 JuanMaFre 2023-09-25T23:54:20Z https://community.fabric.microsoft.com/t5/Developer/C%C3%B3mo-combinar-filas-duplicadas-y-sumar-sus-valores/m-p/3448355#M44686 <P>Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue. <BR />If you are unsure how to do that please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.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 />If you want to get answers faster please refer to <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Tue, 26 Sep 2023 17:40:48 GMT https://community.fabric.microsoft.com/t5/Developer/C%C3%B3mo-combinar-filas-duplicadas-y-sumar-sus-valores/m-p/3448355#M44686 lbendlin 2023-09-26T17:40:48Z