How to use these functions SUMX, AVERAGE ?

Anonymous — Wed, 10 Apr 2024 14:02:24 GMT

Can anyone help how to use these functions SUMX, AVERAGE in Power Bi

Re: How to use these functions SUMX, AVERAGE ?

Anonymous — Thu, 11 Apr 2024 01:07:32 GMT

Hi Anonymous ,

I create the sample table to introduce the SUMX and AVERAGE function.

1.Create the simple table.

2.Create the new measure to calculate SUMX.

M_SUMX = CALCULATE(SUMX('Table', 'Table'[Values]), FILTER('Table', 'Table'[Year] = YEAR(TODAY()) && 'Table'[Month] <= MONTH(TODAY())))

3.Create the new measure to calculate AVERAGE.

AVERAGE_ = AVERAGE('Table'[Values])

4.You can also view the following documents to learn about SUMX and AVERAGE function.

Best Regards,

Wisdom Wu

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