Cumulative CSAT

[kevinedora]

Hi,

I'm trying to recreate what I did on excel to PowerBi and can't seem to find a way to do it.

Please note of the metrics below:

Average - Average Count of Surveys

Cumulative Average - Cumulative of Average Count of Surveys

CSAT - Average CSAT

Cumulative CSAT - Cumulative of Average CSAT (this is what i'm trying to recreate as calculated column)

I already have a column for Average, Cumulative Average, and CSAT but can't seem to find a way to recreate the Cumulative CSAT.

Below what the formula looks like.

And here's what my column looks like in Powerbi.

Please advise. Thank you!

[amitchandak]

@kevinedora , With a date table joined with date of your table you can have measures like

Calculate(averagex(Values(Date[Date]), [Average CSAT],  filter(all('Date'),'Date'[date] <=max('Date'[date])))

Calculate(averagex(Values(Date[Date]), [Average CSAT],  Window(1,ABS,0,REL, ALLSELECTED('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

[amitchandak]

@kevinedora , With a date table joined with date of your table you can have measures like

Calculate(averagex(Values(Date[Date]), [Average CSAT],  filter(all('Date'),'Date'[date] <=max('Date'[date])))

Calculate(averagex(Values(Date[Date]), [Average CSAT],  Window(1,ABS,0,REL, ALLSELECTED('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