The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
This is the summarize table I have.
TFTSUN2 PIVOT = SUMMARIZE(FILTER(Table, Table[Completed?] = "Complete"),Table[Week Ending],Table[Order#],Table[Location],"Production Order Feet",SUM(Table[LTHF]))
I want to combine the order numbers such that Order number 301147, Production feet = 52916 with the Week Ending date February 22, 2020 and 301148, production feet = 52667 with the Week Ending date February 22, 2020.
Solved! Go to Solution.
Hi @Anonymous ,
I don't know your sample data, you could refer to my sample for details.
order feed week end
1 | 11 | Saturday, February 15, 2020 |
1 | 22 | Saturday, February 22, 2020 |
2 | 12 | Saturday, February 15, 2020 |
2 | 11 | Saturday, February 22, 2020 |
Table 2 = SUMMARIZE(T2,T2[order],"WEEK END", CALCULATE(MAX(T2[week end]), ALLEXCEPT(T2,T2[order])), "TOTAL", SUM(T2[feed]))
If this doesn't work, please inform me more detailed information (such as your sample and output, you could use virtual data instead of real data)
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I don't know your sample data, you could refer to my sample for details.
order feed week end
1 | 11 | Saturday, February 15, 2020 |
1 | 22 | Saturday, February 22, 2020 |
2 | 12 | Saturday, February 15, 2020 |
2 | 11 | Saturday, February 22, 2020 |
Table 2 = SUMMARIZE(T2,T2[order],"WEEK END", CALCULATE(MAX(T2[week end]), ALLEXCEPT(T2,T2[order])), "TOTAL", SUM(T2[feed]))
If this doesn't work, please inform me more detailed information (such as your sample and output, you could use virtual data instead of real data)
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , numbers not matching with description
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
This is what I'm wanting the table to look like.
This is what the table that my summarize table summarizes
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.
User | Count |
---|---|
138 | |
109 | |
83 | |
69 | |
59 |
User | Count |
---|---|
258 | |
128 | |
116 | |
100 | |
80 |