Forum Discussion

Kfausch's avatar
Kfausch
Icon for Helper II rankHelper II
7 years ago
Solved

How to SUM a measure using MAX

I have a table in which I am trying to calculate product waste, the issue is I need to SUM the yield but only on the last entry for a particular document.   This is the forumla I am currently using...
Need Help
  • ThomVF's avatar
    ThomVF
    7 years ago

    I see what you mean - have you considered creating a deduped version of the table then calculating for each row, eliminating the dedupe inside the calc? 

ThomVF's avatar
ThomVF
Icon for Advocate IV rankAdvocate IV
7 years ago

I see what you mean - have you considered creating a deduped version of the table then calculating for each row, eliminating the dedupe inside the calc? 

Kfausch's avatar
Kfausch
Icon for Helper II rankHelper II
7 years ago

This took a while, but I was able to make it work this way. I feel as though there must be a formula that can be used, but I am happy it is working. Thank you for your suggestions!

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Kfausch ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please share the data sample and your desired output so that we could help further on it.

    Best  Regards,

    Cherry