Forum Discussion
Average and standard deviation analysis
Hi everyone,
could you help me in this situation below:
tABLE 1 - dATA
| PRODUCT | DAY DATE | UNIT | VALUE |
| A | 01/01/2023 | KG | 15.000 |
| A | 02/01/2023 | KG | 12.500 |
| A | 03/01/2023 | KG | 14.200 |
| A | 04/01/2023 | KG | 15.300 |
| A | 05/01/2023 | KG | 15.420 |
| A | 06/01/2023 | KG | 12.000 |
| B | 01/01/2023 | KG | 12.500 |
| B | 02/01/2023 | KG | 15.000 |
| B | 03/01/2023 | KG | 16.000 |
| B | 04/01/2023 | KG | 17.000 |
| B | 05/01/2023 | KG | 17.520 |
| B | 06/01/2023 | KG | 18.250 |
tABLE 2 - summary
| PRODUCT | MONTH DATE | UNIT | DAILY AVERAGE | DAILY STANDARD DEVIATION |
| A | jan/2023 | KG | 14.070 | 1.481 |
| B | jan/2023 | KG | 16.045 | 2.079 |
hOW CAN i DO IT in dax
Thanks
William
You can create the following mesasures
DAILY AVERAGE = AVERAGE('Table'[VALUE]) DAILY STANDARD DEVIATION = STDEV.S('Table'[VALUE])Output
You can refer to the following links to know more about the related function.
STDEV.S function (DAX) - DAX | Microsoft Learn
AVERAGE function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
You can create the following mesasures
DAILY AVERAGE = AVERAGE('Table'[VALUE]) DAILY STANDARD DEVIATION = STDEV.S('Table'[VALUE])Output
You can refer to the following links to know more about the related function.
STDEV.S function (DAX) - DAX | Microsoft Learn
AVERAGE function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.