Forum Discussion
x
Anonymous , could you provide a bit more information on what your expected output looks like?
Have you tried something like Split by Delimiter or Column from Examples?
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.
Anonymous can you please clearly provide sample data and expected output in a table format and not picture?
Anonymous Just create a new calculated column:
Column2 = "Water"
Use that in your visual instead of the other Column1
