cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## WINDOW_SUM POWER BI

Hi,

I am using the following Tableau formula:

WINDOW_SUM(SUM([Measure1]),FIRST(),FIRST()+[ParameterTopReason]-1) /

WINDOW_SUM(SUM([Measure2]),FIRST(),FIRST()+[ParameterTopReason]-1)

I need to convert this formula to Power Bi.

Thanks!

1 ACCEPTED SOLUTION
Super User

@gabriela09 , In power bi we have a window function , but does not work on visual rows. it need the parameter

example

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

LAst 30 days  = CALCULATE([Net], Window(-29,REL,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Super User

@gabriela09 , In power bi we have a window function , but does not work on visual rows. it need the parameter

example

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

LAst 30 days  = CALCULATE([Net], Window(-29,REL,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors