Sum columns from different fact tables

Anonymous — Thu, 21 Oct 2021 18:45:39 GMT

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?

Re: Sum columns from different fact tables

amitchandak — Fri, 22 Oct 2021 04:29:06 GMT

Anonymous , Append these tables in power query

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

topic Sum columns from different fact tables in DAX Commands and Tips

Sum columns from different fact tables

Re: Sum columns from different fact tables