Forum Discussion

mk244's avatar
mk244
Frequent Visitor
8 years ago

Table Calculations

Hello!   I'm trying to recreate a Tableau report in Power BI. The report has many table calculations using Window_Sum(), Window_Avg() and Lookup(). Is there a way to perfrom these calculations in P...
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi mk244,

 

Power BI provides powerful DAX(Data Analysis Expressions) function which can help you create new information from data already in your model. DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. You can refer to DAX reference here for more details: https://msdn.microsoft.com/en-us/query-bi/dax/data-analysis-expressions-dax-reference.

 

Regards,

Jimmy Tao