Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |