Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

Hi, 

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

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

 

basically, 

 

Table 1....to 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.

2 REPLIES 2
Anonymous
Not applicable

Use Addcolumns() and summerize() function.

Anonymous
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

 

Table = ADDCOLUMNS(
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors