Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a table from different columns of each table with date filter and aggregate the column


I have 8 different data tables with calculated measures & columns. 

I want to create a new table from columns of each table.




Table Table 8 with approximately 15 columns each 


what I want is, below

New table, column 1 = sum of ( Average of calculated column 1 of Table 1 +...+ average of calculated column 1 of table 😎

                  Column 2 = sum of ( Average of calculated column 2 of Table 1 +....+ average of calculated column 2 of table 😎




                 Column 8 = sum of ( Average of a calculated column 8 of Table 1 +....+ average of calculated column 8 of table 😎


All the above-calculated column in the new table will use date slicer in visuals.  

Help me, please.

Not applicable

Use Addcolumns() and summerize() function.

Not applicable

Thank you @Anonymous .


But still, I don't get what I needed. 


I have used this script, let me know am I using it right


SUMMARIZE(Apex_1,Apex_1[Date].[Date]),"apex 1 availability",[Availability Apex_1])
apex 1 is the existing table name
Apex 1 availability is a new column name
Availability Apex_1 is the calculated measure
what I need in here is, the average of calculated measure is 1432 respective to apex_1 date
I need the same average to the new column corresponding to the date
Help me please

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

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

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors