Weekly Average and Weekly Std Dev

Question

Hi Team,Could you help me with this query.I need&nbsp;Weekly Average and Weekly Std Dev of parameters for research purpose:-Table data:-&nbsp;DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COND1st Jan 2020&nbsp; &nbsp; &nbsp; &nbsp;8.6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40002nd Jan 2020&nbsp; &nbsp; &nbsp; 8.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50008th Jan 2020&nbsp; &nbsp; &nbsp; &nbsp;9.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30009th Jan 2020&nbsp; &nbsp; &nbsp; &nbsp;9.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5000Solution needed (format)parameter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(weekly avg) week 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;week 2pH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4500Conductivity&nbsp; &nbsp; &nbsp; &nbsp; 9.75&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4000parameter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(weekly Std Dev) week 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;week 2pH&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4575Conductivity&nbsp; &nbsp; &nbsp; &nbsp; 9.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4011&nbsp;Please let me know in case of any further information needed from my side.Thanks for your help!&nbsp;Regards,S

mahesh0016 · Answer

Sumeesh&nbsp;&gt; First you create WeekNum Column then&gt; Ph = calculate(sum(table[pH]),ALLEXPECTED(Table,Table[WeekNum]))&gt; Avg_Ph = AVERAGEX(ALLEXPECTED(Table,Table[WeekNum]),[Ph])Sumeesh&nbsp;I hope this helps you!THANK YOU!!

Forum Discussion

Weekly Average and Weekly Std Dev

1 Reply

Related content

Weekly Average

Weekly running average

Average Weekly Sales

formula to calculate weekly average

Weekly visualization