Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |