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

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

Reply
gabriela09
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
amitchandak
Super User
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.

View solution in original post

1 REPLY 1
amitchandak
Super User
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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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