Add an average column

Hi Anonymous ,

Has your problem been solved?

If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

I noticed that your formula could be modified as:

calculate(sum('2023 RM Raw Data'[Amount]), filter(allselected('2023 RM Raw Data'),[groupfield]=max('2023 RM Raw Data'[groupfield]))/12

filter(allselected('2023 RM Raw Data'),[groupfield]=max('2023 RM Raw Data'[groupfield])

The above is to calculate the sum of a whole year in groups. You can modify this based on the fields in the rows in the matrix.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Stephen Tao