Obtener el saldo y Arrastre

[ylsemv]

Hola,

Estoy tratanto de realizar la siguiente tabla en PBI pero no logró obtener el resultado esperado para calcular la fila de "Arrastre de Saldo OC" y "Saldo de OC".

En la siguiente tabla con los datos de entrada que tengo.

Fecha	Ene-2021	Feb-2021	Mar-2021	Abr-2021
Monto OC	$5,106.00	$0.00	$0.00	$0.00
Facturación	$285.00	$120.00	$384.00	$0.00

Y deseo agregar en la tabla las filas de "Arrastre de Saldo OC" y "Saldo de OC". 

Fecha	Ene-2021	Feb-2021	Mar-2021	Abr-2021
Monto OC	$5,106.00	$0.00	$0.00	$0.00
Arrastre de Saldo OC	$5,106.00	$4,821.00	$4,701.00	$4,317.00
Facturación	$285.00	$120.00	$384.00	$0.00
Saldo de OC	$4,821.00	$4,701.00	$4,317.00	$4,317.00

[V-pazhen-msft · Accepted solution]

@ylsemv 

1. You can either use append in the Query Editor

2. Or create a table with Union.

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

[ylsemv]

Hi @amitchandak 

The first table is the data that I have in my model.

Fecha	Ene-2021	Feb-2021	Mar-2021	Abr-2021
Monto OC	$5,106.00	$0.00	$0.00	$0.00
Facturación	$285.00	$120.00	$384.00	$0.00

The new rows that I want to calculate is "Arrastre de Saldo OC" and "Saldo de OC" found in the second table.

Fecha	Ene-2021	Feb-2021	Mar-2021	Abr-2021
Arrastre de Saldo OC	$5,106.00	$4,821.00	$4,701.00	$4,317.00
Saldo de OC	$4,821.00	$4,701.00	$4,317.00	$4,317.00

Result

Fecha	Ene-2021	Feb-2021	Mar-2021	Abr-2021
Monto OC	$5,106.00	$0.00	$0.00	$0.00
Arrastre de Saldo OC	$5,106.00	$4,821.00	$4,701.00	$4,317.00
Facturación	$285.00	$120.00	$384.00	$0.00
Saldo de OC	$4,821.00	$4,701.00	$4,317.00	$4,317.00

Thank

[amitchandak]

@ylsemv , the first table seems like a filter on the second table?

Am I missing something?

Check

https://docs.microsoft.com/en-us/dax/calculatetable-function-dax