Weekly Average and Weekly Std Dev

[Sumeesh]

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 2020       8.6             4000

2nd Jan 2020      8.8             5000

8th Jan 2020       9.7             3000

9th Jan 2020       9.8             5000

Solution needed (format)

parameter         (weekly avg) week 1         week 2
pH                       8.8                                     4500
Conductivity        9.75                                  4000

parameter         (weekly Std Dev) week 1         week 2
pH                       8.7                                        4575
Conductivity        9.5                                       4011

Please let me know in case of any further information needed from my side.
Thanks for your help!

Regards,
S

[Mahesh0016]

@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!!