Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mk244
Frequent Visitor

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

1 ACCEPTED SOLUTION
BKirsch12
Resolver II
Resolver II

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.

 

View solution in original post

5 REPLIES 5
BKirsch12
Resolver II
Resolver II

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 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.