Combine multiple rows into one row
I have the following table Name ID1 Item Type ID2 ID3 USD Amount ID4 Rank Contracts Notes Bank1 8910 Bank1 100 SH782 400 Bank1 123 Vendor Bank1 456 Utilizing DAX or Power Query, I need it to be transformed to the following Name ID1 Item Type ID2 ID3 USD Amount ID4 Rank Contracts Notes Bank1 123 Vendor 8910 456 100 SH782 400 I utilized the SUMMARIZE function and pulled all of those datafields into it, but still get the rows being separated.
Group values together based on field value and create new combined value
Hi looking for a way to do this without creating a separate Table or a calculated Column. But looking for way to create a Measure that would combine a Sales Category for only certain Customers into a new combined value. See below, Lets lets say Customer Bill Gates has sales in multiple Sales Category and I'm looking to create a Measure that says" If Customer="Bill Gates" then combine Sales Category, else show Sales Category. So looking for 1. Ability to statically enter Certain\multiple Customers to apply this to 2. Ability to statically list certain\multiple Sales Categories that I want to combine and the other Sales category will just be listed as normal. 3. Name this new comobined value any name that I want. Anyone have any ideas on how to do this with a measure? See example below. Before results: Customer Sales Category Sales$ Bill Gates Software 1,000 Bill Gates Hardware 500 Bill Gates Internet 200 Bill Nine Science 200 Tiger Woods Golf 99999 Tiger Woods Promo 5 Expected Results: ( I would put in the Measure 2 things, Customer Name = "Bill Gates", and Sales Category to combine = "Software" and "Hardware" ) and have the new Combined Value be called "Combined" Customer Sales Category Sales$ Bill Gates Combined 1,500 Bill Gates Internet 200 Bill Nine Science 200 Tiger Woods Golf 99999 Tiger Woods Promo 5