Forum Discussion
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!
Anonymous , 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-3d98a5b0e07fIf this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
1 Reply
- amitchandak
Super User
Anonymous , 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-3d98a5b0e07fIf this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.