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? Thanks
Solved! Go to Solution.
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.
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.
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.
User | Count |
---|---|
108 | |
63 | |
60 | |
37 | |
37 |
User | Count |
---|---|
110 | |
67 | |
62 | |
60 | |
50 |