cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JonSnow777
Frequent Visitor

x

 
6 REPLIES 6
v-xiaotang
Community Support
Community Support

Hi @JonSnow777 

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
Super User
Super User

@JonSnow777 , 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. 

JonSnow777_0-1636482397164.png

I am trying to end up with Somthing like this:

JonSnow777_2-1636482597280.png

 

where i add the two values together 

 

 

@JonSnow777 Just create a new calculated column:

 

Column2 = "Water"

 

Use that in your visual instead of the other Column1


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


Thanks @JonSnow777 

 

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.

 

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!