Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summarize table 2 entries with different dates make them same date

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.

Need Help
Tutorial Requests
  • dax's avatar
    dax
    6 years ago

    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.

3 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

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

       

      This is what the table that my summarize table summarizes