Sum columns from different fact tables

[GabrielCOLI]

Hello, good afternoon.

I need help to resolve the following situation.

I have two fact tables, where both have a column called TotalSale in the first has data only from Empresa1 and the other from Empresa2, where I made a relationship in an intermediate table called Empresas.

I would like to create a table like the one above where my first column receives as business rows (intermediate table), I have another dimension table with the dates, and where is 2020 is summed the columns TotalSale of both tables facts.

I made the following formula for the year 2020:

Faturamento Ano Anterior = Calculate(sum(fato_Pro_FaturamentoPorItens[TotalVenda]),Value(dim_Tempo[Ano])=YEAR(Now())-1)

With this formula I get the sum of only one Fact table, how to sum the TotalSale column of the other Fact table?

[GabrielCOLI]

I need help to resolve the following situation.

I have two fact tables, where both have a column called TotalSale in the first has data only from Empresa1 and the other from Empresa2, where I made a relationship in an intermediate table called Empresas.

I would like to create a table like the one above where my first column receives as business rows (intermediate table), I have another dimension table with the dates, and where is 2020 is summed the columns TotalSale of both tables facts.

I made the following formula for the year 2020:

Faturamento Ano Anterior = Calculate(sum(fato_Pro_FaturamentoPorItens[TotalVenda]),Value(dim_Tempo[Ano])=YEAR(Now())-1)

With this formula I get the sum of only one Fact table, how to sum the TotalSale column of the other Fact table?

[amitchandak]

@GabrielCOLI , Append these tables in power query

or

create common dimensions like time, geography and one for Empresa1  and Empresa2( Table with two values.

Then using these dimensions you can analyze measures together can add those measures to get total across two tables