I have 8 different data tables with calculated measures & columns.
I want to create a new table from columns of each table.
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.
Use Addcolumns() and summerize() function.
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
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!