Restar Valores de dos tablas

[Anonymous]

Buenas tardes. 

Deseo su ayuda quiero sacar un delta o diferencias de valores de dos tablas diferentes, ya que los campos del nombre son iguales pero los valores a veces cambian y queiro saber cuál es la diferencia o una resta de la tabla A con la Tabla B y viceversa.

Por ejempl como la imagen en el mes de mayo tuvo 8 valores en la tabla A y en la tabla B tuve 25, segun la diferencia seria: 17

[amitchandak · Accepted solution]

@Anonymous , You need to have common dimensions, Date, and services. Then you can

You display measure together and have diff too

Sum(Table1[Value]) - Sum(Table2[Value])

refer if needed

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Not sure about your table structure, I assume there are two tables with the same fields. Create a one-to-one relationship between the service IDs and then create the following column:

delta = CALCULATE(SUM('Table1'[Value])-CALCULATE(SUM(Table2[Value])))

Sample data:

Result:

Please refer to the attachment below for details

If it doesn't work for you, then please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jeison]

Buenas tardes

Como  puedo obtener resta entradas menos salidas y que se aplique a cada posición

[Anonymous]

Muchas gracias, ahora lo que tengo que hacer es poder mostar, solo los datos que tengan un delta osea que de los 100 registros que tengo, 25 tienen delta solo debo mostrar aquellos nombres y valores que tienen una diferencia es posible hacer eso?

[amitchandak · Accepted solution]

@Anonymous , You need to have common dimensions, Date, and services. Then you can

You display measure together and have diff too

Sum(Table1[Value]) - Sum(Table2[Value])

refer if needed

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Muchas gracias, ahora lo que tengo que hacer es poder mostar, solo los datos que tengan un delta osea que de los 100 registros que tengo, 25 tienen delta solo debo mostrar aquellos nombres y valores que tienen una diferencia es posible hacer eso?

[Anonymous]

Hello, thank you very much for your answer, but what I need is first to compare the lines and find the difference per line, from what I see you tell me the total.