Summarize table 2 entries with different dates make them same date

[Anonymous]

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.

[dax · Accepted 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.

[amitchandak]

@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.

[Anonymous]

@amitchandak 

This is what I'm wanting the table to look like.

This is what the table that my summarize table summarizes