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