Forum Discussion
Column conditional formatting and running Average chart
I am trying to create a column and line chart using data from MS Project, pulled into Excel (because I couldn't work out how to calculate the "running" average of the RAGs up to "this" week - easy in...
HI Anonymous ,
Pls test the below measure:
AV1 = CALCULATE(SUM('Table'[Average])/COUNT('Table'[RAG]),FILTER(ALL('Table'),'Table'[Weekend]<=MAX('Table'[Weekend])))Best Regards
Lucien
HI Anonymous ,
Pls test the below measure:
AV1 = CALCULATE(SUM('Table'[Average])/COUNT('Table'[RAG]),FILTER(ALL('Table'),'Table'[Weekend]<=MAX('Table'[Weekend])))
Best Regards
Lucien