The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
62 | |
53 | |
51 |