cancel
Showing results for
Did you mean:
Frequent Visitor

## DAX sum of square of weekly sales

Hi.

I have a measure [Sales Quantity2] that is defined as the sum of a column Sales[Quantum].

Now I want to calculate the std.dev and mean of [Sales Quantity2] for a given period. Week by week. The mean is easy, just calculate [Sales Quantity2] divided by number of weeks.

To calculate the std.dev I need to sum up quantum for an entire week, square it, and then sum over weeks. How to do this?

I.e. need to make a measure that can sum up SQ3 in this table

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: DAX sum of square of weekly sales

can you post sample anonymised data?

in general I'd go with STDEVX.P or STDEVX.S  & SUMMARIZE
https://docs.microsoft.com/en-gb/dax/stdevx-s-function-dax

```Measure =
STDEVX.S (
ADDCOLUMNS ( SUMMARIZE ( Table, Table[Week No] ), "SQ2", [Sales Quantity2] ),
[SQ2]
)```

you would need to adjust blue description and maybe replace STDEVX.S with STDEVX.P

Proud to be a Datanaut!

2 REPLIES 2
Super Contributor

## Re: DAX sum of square of weekly sales

can you post sample anonymised data?

in general I'd go with STDEVX.P or STDEVX.S  & SUMMARIZE
https://docs.microsoft.com/en-gb/dax/stdevx-s-function-dax

```Measure =
STDEVX.S (
ADDCOLUMNS ( SUMMARIZE ( Table, Table[Week No] ), "SQ2", [Sales Quantity2] ),
[SQ2]
)```

you would need to adjust blue description and maybe replace STDEVX.S with STDEVX.P

Proud to be a Datanaut!

Highlighted
Frequent Visitor

## Re: DAX sum of square of weekly sales

Worked great. Thanks

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 324 members 3,790 guests
Recent signins: