WINDOW_SUM POWER BI

[gabriela09]

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!

[amitchandak · Accepted solution]

@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.