Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

GROUP BY logic

Hi,   Consider the sample data below.     FG - Finished Good RM - Raw Material I want to calculate the yield value for a finished good (it's already calculated in the table above for und...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Perhaps something like:

    Yield = 
VAR maxRMCost = MAX(Yields[RM Cost])
VAR tmpTable = FILTER(Yields,[RM Cost]=maxRMCost)
RETURN SUMX(tmpTable,[FG Qty]) / SUMX(tmpTable,[RM Qty])

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Can you mark the proper answer as a solution please?

 

Best Regards,

Dale