Forum Discussion

arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
3 years ago

Average on selected Value

Hi,

 

  Need to calcuate Average on selected Value.

ProductStyle NoSale QtyAvg Sales QtySales Qty/ Avg Sales Qty
CD SET1306.264.79
CD SET2286.264.47
CD SET3146.262.24
CD SET4136.262.08
CD SET5116.261.76
CD SET696.261.44
CD SET786.261.28
CD SET876.261.12
CD SET976.261.12
CD SET1066.260.96
CD SET1166.260.96
CD SET1256.260.80
CD SET1356.260.80
CD SET1446.260.64
CD SET1546.260.64
CD SET1646.260.64
CD SET1746.260.64
CD SET1846.260.64
CD SET1946.260.64
CD SET2036.260.48
CD SET2136.260.48
CD SET2236.260.48
CD SET2336.260.48
CD SET2436.260.48
CD SET2536.260.48
CD SET2636.260.48
CD SET2736.260.48
CD SET2836.260.48
CD SET2936.260.48
CD SET3026.260.32
CD SET3126.260.32
CD SET3226.260.32
CD SET3326.260.32
CD SET3426.260.32

 

@amitchauhan @bvanderwatt @ray_ux @tamerj1 @SpartaBI @v-chenyue-msft  @mangaus1111

@v-jianhe-msft 

9 Replies

    • arvindarvind24's avatar
      arvindarvind24
      Icon for Helper II rankHelper II
      3 years ago

      FYI.

      Table1Table1Table1Table1Table2Based on Product I need the Avg (Result Required)
      ProductSizeStyle NoColourSale QtyAvg Sales Qty
      Product01S1Red3012.63
      Product01M2Black2812.63
      Product01XL3Green1412.63
      Product01XXL4Red1312.63
      Product01S5Black1112.63
      Product01M6Green912.63
      Product01XL7Red812.63
      Product01XXL8Black712.63
      Product01S9Green712.63
      Product01M10Red612.63
      Product01XL11Black612.63
      Product02S12Green53.83
      Product02M13Red53.83
      Product02XL14Black43.83
      Product02XXL15Green43.83
      Product02S16Red43.83
      Product02M17Black43.83
      Product02XL18Green43.83
      Product02XXL19Red43.83
      Product02S20Black33.83
      Product02M21Green33.83
      Product02XL22Red33.83
      Product02S23Black33.83
      Product03XL24Green32.54
      Product03XXL25Red32.54
      Product03S26Black32.54
      Product03M27Green32.54
      Product03XL28Red32.54
      Product03XXL29Black32.54
      Product03S30Green22.54
      Product03M31Red22.54
      Product03XL32Black22.54
      Product03M33Green22.54
      Product03M34Red22.54
      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

        arvindarvind24 
        How are table1 and Table2 connected? Are looking for a measure or a calculated column?

  • arvindarvind24's avatar
    arvindarvind24
    Icon for Helper II rankHelper II
    3 years ago

    Hi tamerj1 ,

    Based on product i need the average.

    ProductSizeStyle NoColourSale QtyAvg Sales QtySales Qty/ Avg Sales Qty
    Product01S1Red3012.632.38
    Product01M2Black2812.632.22
    Product01XL3Green1412.631.11
    Product01XXL4Red1312.631.03
    Product01S5Black1112.630.87
    Product01M6Green912.630.71
    Product01XL7Red812.630.63
    Product01XXL8Black712.630.55
    Product01S9Green712.630.55
    Product01M10Red612.630.48
    Product01XL11Black612.630.48
    Product02S12Green53.831.31
    Product02M13Red53.831.31
    Product02XL14Black43.831.04
    Product02XXL15Green43.831.04
    Product02S16Red43.831.04
    Product02M17Black43.831.04
    Product02XL18Green43.831.04
    Product02XXL19Red43.831.04
    Product02S20Black33.830.78
    Product02M21Green33.830.78
    Product02XL22Red33.830.78
    Product02S23Black33.830.78
    Product03XL24Green32.541.18
    Product03XXL25Red32.541.18
    Product03S26Black32.541.18
    Product03M27Green32.541.18
    Product03XL28Red32.541.18
    Product03XXL29Black32.541.18
    Product03S30Green22.540.79
    Product03M31Red22.540.79
    Product03XL32Black22.540.79
    Product03M33Green22.540.79
    Product03M34Red22.540.79

     

    ProductSales QtyAvg Value
    Product0113912.63
    Product02463.83
    Product03282.54
  • arvindarvind24's avatar
    arvindarvind24
    Icon for Helper II rankHelper II
    3 years ago

    Hi All,
      After using the ALLEXCEPT the value is not getting.


     

    Result Wanted: