Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table Table 1 having these below columns (A1, B1, C2, A2, B2, C2).
I need to create another table Table 2 with A, B and C as row values under the column "Type" and two other columns, 1 and 2 under which I should have the sum(A1), sum(A2) and so on.
Table 1
A1 B1 C1 A2 B2 C2
- - - - ----
- - - ------
- - --------
Table 2
Type 1 2
A Sum(all values under A1)
B
C
Mate, such tasks belong to the ETL world rather than DAX. Please use Power Query for this (as rightly suggested by the other reader).
Best
Darek
In Power Query:
Select all columns.
Unpivot them.
This should give you 2 columns (the first will have A1, B1, C1 etc).
Split the first column (by number of characters - which will be 1, as far left as possible).
This will give you 3 columns.
Select the middle column.
Pivot the column.
Rename your columns as required.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |