Forum Discussion

Sumeesh's avatar
Sumeesh
Regular Visitor
3 years ago

Weekly Average and Weekly Std Dev

Hi Team, Could you help me with this query. I need Weekly Average and Weekly Std Dev of parameters for research purpose:- Table data:-   DATE                  pH              COND 1st Jan...
Need Help
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

Sumeesh 
> First you create WeekNum Column then
> Ph = calculate(sum(table[pH]),ALLEXPECTED(Table,Table[WeekNum]))
> Avg_Ph = AVERAGEX(ALLEXPECTED(Table,Table[WeekNum]),[Ph])

Sumeesh I hope this helps you!THANK YOU!!