Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |