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 this table, where I have multiple rows equals and the only difference between them is the Value:
ID | Status | Desc | Value |
1 | A | xx | 1,5 |
1 | A | xx | 1,5 |
1 | A | xx | 1 |
2 | B | aa | 2 |
2 | B | aa | 3 |
So I need to modify this table in order to get this:
ID | Status | Desc | Value |
1 | A | xx | 4 |
2 | B | aa | 5 |
I need to combine or summarize the values when the other columns are equal.
Thanks for your help!
Solved! Go to Solution.
You can use Group By
In the query editor, right click on your ID column, and choose group by.
In the window choose advanced, and group by the 3 columns and create a sum operation for Value:
You can use Group By
In the query editor, right click on your ID column, and choose group by.
In the window choose advanced, and group by the 3 columns and create a sum operation for Value:
If you so sum of Value in Table or matrix it should work ?
Or new table like
new table = summarize(Table,Table[ID],Table[Status],Table[Desc],"Value Sum",sum(Table[Value]))
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |