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

Frequent Visitor

## Re: DAX sum of square of weekly sales

Worked great. Thanks

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 117 members 1,541 guests
Recent signins: