Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Can anyone help how to use these functions SUMX, AVERAGE in Power Bi
Solved! Go to Solution.
Hi @Sashi_tripathi ,
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.
AVERAGE function (DAX) - DAX | Microsoft Learn
SUMX function (DAX) - DAX | Microsoft Learn
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.
Hi @Sashi_tripathi ,
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.
AVERAGE function (DAX) - DAX | Microsoft Learn
SUMX function (DAX) - DAX | Microsoft Learn
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
12 | |
11 | |
8 | |
7 | |
7 |
User | Count |
---|---|
20 | |
14 | |
11 | |
10 | |
10 |