DAX Measure: Sum specific column from all Identical Tables

[mirology]

Hello everyone ,

So i have N Number of Tables containing data (Table1, Table2, Table3 ,.... Table N) all of which have the same column names inside ( for example Table1[Sales] .. Table2[Sales] ) also those tables are related to a Calendar table by "Date".


I want to create a measure that sum [Sales] From all those tables without having to type "= Sum(Table1[Sales]) +Sum(Table2[Sales]) + ... Sum(TableN[Sales )) as i have alot of tables and writing a very long equation like this will be inefficient

 

[MSBINinja]

Why don't you append these tables using power query? if not then you will have to create a new calculated table using UNION, that could be a bit messy and will increase the size of your model.

 

[mirology]

Yeah i have thought about those methods and found them inefficient and as you have said it will increase Model Size ... i have managed for now to have a work-around using VBA to automate the process of creating the measure Formula "= Sum(Table1[Sales]) +Sum(Table2[Sales]) + ... Sum(TableN[Sales )) by looping through a table containg table names