Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |