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.
Folks, need a help. I receive from a system the following table:
Engagement ID | Valeu USD | Status |
12345 | 100 | Active |
12345 | 200 | Active |
12345 | -400 | Active |
12345 | 600 | Active |
12345 | 200 | Active |
I need to transform it in something like this in a easy way using PBI
Engagement ID | Valeu USD | Status |
12345 | 700 | Active |
I´ve been strugling to work with this data and I believe these duplicates fields are the reason. Any help?
Solved! Go to Solution.
You can use group by in the edit queries, then advance and add multiple column(Screenshot below)
Hey @Anonymous
You can use the following DAX expression once the data has been imported into PBI:Consolidated Table =
SUMMARIZE( EngagementID, EngagementID[Status], EngagementID[Engagement ID], "Value USD", SUM(EngagementID[Value USD]) )
Click HERE to access my PBIX file if needed.
You can use group by in the edit queries, then advance and add multiple column(Screenshot below)
I believe this can be achieved using Group By on power query.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyNjFV0lEyNDAAko7JJZllqUqxOggJI1wSuia4ZMyIMysWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Engagement ID" = _t, #"Valeu USD" = _t, Status = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Engagement ID", Int64.Type}, {"Valeu USD", Int64.Type}, {"Status", type text}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"Engagement ID", "Status"}, {{"Value USD", each List.Sum([Valeu USD]), type number}}) in #"Grouped Rows"
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |