Forum Discussion
Cumulative CSAT
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!
2 Replies
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-3d98a5b0e07fkevinedora , 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
