cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Matt-Snyder
Frequent Visitor

Tableau's WINDOW_SUM Equivalent in DAX

Hello everyone,

 

I am creating a report based on one done previously in Tableau.

 

There's a Net Sales Average calculation that uses Tableau's WINDOW_SUM functions to just get the 3 rows above the current and divide by three to get the running net sales average.

 

Here's what it looks like:

 

WINDOW_SUM(SUM([Net Sales]), -3,-1)/3

 

What would be the DAX equivalent to this function?

 

Thanks!

1 REPLY 1
ribisht17
Super User
Super User

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors