Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using 'product' function by group

Hi,    With original Table 1,    First, I would like to multiply Rate% by the same WO no. From Table 1; I am not sure which fomular I should use such that only multiply for the same group in WO c...
  • tamerj1's avatar
    4 years ago

    Anonymous 

    Not sure if I correctly understand, but please try 

    Yield % =
    VAR T1 =
        SUMMARIZE (
            TableName,
            TableName[WO],
            TableName[Product],
            "@Yield", PRODUCT ( TableName[Rate] )
        )
    RETURN
        AVERAGEX ( T1, [@Yield] )