Average and standard deviation for all values

[Mariano_oz]

Hi Everyone!

I need help for the average and standard deviation formulas.

I have 2 Tables:

1 table is a calendar with working days

the 2 one is a table with the revenue for 1 item per day.

so I have                                                   Revenue Table        

Working days                       Posting Date            Item         Quantity          

01/01/2021                          01/01/2021               Pen               1   

02/01/2021                          03/01/2021               Pen               2

03/01/2021                          04/01/2021               Pen               3 

04/01/2021

05/01/2021

I have to calculate Average and Standard deviation of the item on 5 days instead of 3 days.

For the average is quite simple doing : sum(quantity)/count(workingdays), but how can I do for the standard deviation?

I would try to use the standard dax measure (average/averagex-STDEV.P) with correct contest filter. Is it possible?

Let me know!

[v-alq-msft]

Hi, @Mariano_oz 

Could you please show us  some sample data and the expected result for better understanding with OneDrive for business? Do mask sensitive data before uploading. Thanks.

Best Regards

Allan