Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have data source that contains thousands of Sales Orders. Each Sales Order can have multiple lines on the order, so most of the data is the same across each row. However, there are a few differences and I would like to create a summary table that essentially rolls-up certain information for each unique Sales Order #.
Here is a very simple example of what I am looking to do.
When all is said and done I will have multiple columns that I will be performing basic math on, but I'd hope if I can do it for one, it will be easy to replicate.
Can anyone help me out?
Solved! Go to Solution.
@Anonymous
try this in PQ
Table 2 = SUMMARIZE('Table','Table'[sales order],"cost",sum('Table'[cost],"count",COUNTROWS('Table'))
or try this to use DAX to create a table
Proud to be a Super User!
@Anonymous
you can try group by in pq
or use DAX to create a new table
Table 2 = SUMMARIZE('Table','Table'[sales order],"cost",sum('Table'[cost]))
Proud to be a Super User!
Thank you! Is there a way I can also create a column that counts how many lines were essentially rolled u? In this case 3 for each.
@Anonymous
try this in PQ
Table 2 = SUMMARIZE('Table','Table'[sales order],"cost",sum('Table'[cost],"count",COUNTROWS('Table'))
or try this to use DAX to create a table
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
39 | |
33 |
User | Count |
---|---|
71 | |
66 | |
57 | |
49 | |
47 |