cancel
Showing results for
Did you mean:
Frequent Visitor

## Calcular la diferencia entre un mes y otro

Buenos dias

Quisera saber como calcular la diferencia entre los valores de cada mes, tengo el siguiente archivo, en donde quiero calcular la diferencia, cada mes corresponde a una tabla diferente, sin realizar la suma total solo realizar la diferencio por cada concepto por cada mes

2 REPLIES 2
Community Support

Hi  @DannaLA526 ,

I created some data:

1Month:

You can use the SELECTCOLUMNS() and Sumx() functions to load the data you want from each table into a table

Here are the steps you can follow：

1. Create calculated table.

``````Table =
DISTINCT(
SELECTCOLUMNS(
'1Month',
"1Month",
SUMX(FILTER(ALL('1Month'),'1Month'[Concepto]="Total"),[Amount]),
"2Month",
SUMX(FILTER(ALL('2Month'),'2Month'[Concepto]="Total"),[Amount]),
"3Month",
SUMX(FILTER(ALL('3Month'),'3Month'[Concepto]="Total"),[Amount])))``````

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Frequent Visitor

Lo que entiendo es que debo crear una tabla o columna para cada concepto y columna?, ya que cuando lo hago no me tiene en cuenta las columnas, las tablas muestra los resultados por tempresa y concepto

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors