x

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

I noticed that your problem description has been deleted. Has the problem been resolved? If yes, could you accept the answer helpful as solution to help others find it quickly? If not, could you add more details so that we can help you further? Thanks 🙂

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[mattww]

@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?

[Anonymous]

@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 

[Greg_Deckler]

@Anonymous Just create a new calculated column:

Column2 = "Water"

Use that in your visual instead of the other Column1

[smpa01]

@Anonymous  can you please clearly provide sample data and expected output in a table format and not picture?

[mattww]

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.