This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Hello!
I'm trying to recerate a Tableau report in Power BI. The report has come table calculations like Wimdow_Sum, Window_Avg.
Is there a way to perform such table calcuations in Power BI?
Thanks
Solved! Go to Solution.
DAX mathematical documentation can be found here: https://msdn.microsoft.com/en-us/query-bi/dax/math-and-trig-functions-dax
You'll find SUM,SUMX,AVERAGE,AVERAGEX will be the ones to start with. It's probably worthwhile to learn the CALCULATE function as well.
DAX mathematical documentation can be found here: https://msdn.microsoft.com/en-us/query-bi/dax/math-and-trig-functions-dax
You'll find SUM,SUMX,AVERAGE,AVERAGEX will be the ones to start with. It's probably worthwhile to learn the CALCULATE function as well.
Thank you. Was able to recreate all table calculations using SUMX, AVERAGEX, CALCULATE and VAR-RETURN.
Hello MK, could you please let me know what your equivalent function was for this ?
Awesome, glad to help. If you could mark my suggestion as a solution to help future people with a similar question, that'd be great.
Done 🙂
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 30 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 61 | |
| 50 | |
| 30 | |
| 23 | |
| 23 |