Forum Discussion
x
mattww This is the matrix table i am working on.
I am trying to end up with Somthing like this:
where i add the two values together
Thanks Anonymous
Ok, I would suggest creating a new column using Text.BeforeDelimiter in Power Query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCncMcQ1S0FVwC3J0VtJRMjE2NTQ3VYrVQcgEhPsCJXRNjA3NzYz0zAyVYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Description = _t, #"AFE-Field Est" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Description", type text}, {"AFE-Field Est", type number}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "DescriptionSplit", each Text.BeforeDelimiter([Description]," - ")),
#"Grouped Rows" = Table.Group(#"Added Custom", {"DescriptionSplit"}, {{"AFE-Field Est (agg)", each List.Sum([#"AFE-Field Est"]), type nullable number}})
in
#"Grouped Rows"
The Grouping in Power Query may be unneccesary if you want to do your aggregations in DAX when building your visuals.
Alternatively, you could create a dimension table to attach to your budget code.
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.