Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kblommer
Frequent Visitor

Combine multiple rows and retain values of each individual row

I have a bunch of usage data corresponding to customer numbers and months in a pivot table. The values are sporadically placed throughout the table. For each customer number, I would like to merge the data into one row. For instance, for customer #10001303, I would like it to read across 5236, 3740, 2244. Some customer numbers won't have usage data for all rows like customer #10001303 does not. Is there a simple way to do this? ThanksCapture7.PNG

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Hello @kblommer 

Rather than pulling the Table[Usage Data] column into your table, try writing a measure to sum the usage data.

Usage = SUM ( Table[Usage Data] )

Then adding the measure to your matrix.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi,

 

I think you can Summarize this Data using MAX.

 

Expressions:

SELECTCOLUMNS(ADDCOLUMN(

                 SUMMARIZE(TABLE, CUSTOMER_NO,"Jan",MAX(JAN),"FEB",MAX(FEB),....."DEC",MAX(DEC)),

                  "CONCATENATED",CONCATENATE([JAN],[FEB],[MAR]...[DEC])

                      ),"Customer_No",[ CUSTOMER_NO],"Concatenated",[CONCATENATED]

)

 

Do give it a Thumbs up and accept as solution if it solves.

jdbuchanan71
Super User
Super User

Hello @kblommer 

Rather than pulling the Table[Usage Data] column into your table, try writing a measure to sum the usage data.

Usage = SUM ( Table[Usage Data] )

Then adding the measure to your matrix.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.