Forum Discussion

Frequent Visitor

8 years ago

Solved

Table Calculations

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

BKirsch12
8 years ago
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.

5 Replies

BKirsch12
Resolver II
8 years ago
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.
- mk244
  Frequent Visitor
  8 years ago
  Thank you. Was able to recreate all table calculations using SUMX, AVERAGEX, CALCULATE and VAR-RETURN.
  - BKirsch12
    Resolver II
    8 years ago
    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.

Related content