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
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 😞