Forum Discussion

Sdhn420's avatar
Sdhn420
Icon for Helper IV rankHelper IV
5 years ago

Same value for all months

Hi,   How can I display same value for Average sales of 3 months measure for all the months?   Example:    Measure - Average sale of 3 months = 300   Code   Month    Avg Sales   qty M100   J...
Need Help
Sdhn420's avatar
Sdhn420
Icon for Helper IV rankHelper IV
5 years ago

Greg_Deckler That kind of works. Its now showing same value across months but for all codes.

 

I have different material codes - 

 

Code   Month    Avg Sales   qty

M100   Jul          300            600

M100  Aug        300            200

M100  Sep         300            450

M200 Jul            400           200

M200 Aug         400           600

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Sdhn420 , Try like

calculate(average(Table[qty]), allexcept(Table, Table[Code]))

  • Sdhn420's avatar
    Sdhn420
    Icon for Helper IV rankHelper IV
    5 years ago


    amitchandak value is changing for each month 😞