cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Average for 3 terms in a row

i mean what this column calculates

Regular Visitor

## Re: Average for 3 terms in a row

I'm currently on my way to get this "sumMeters" I understand the whole idea, left details

Community Support Team

## Re: Average for 3 terms in a row

` Column Name   Column Content "sumMeters", SUM ( Table1[Meters] )`

These are one pair of parameters.  Column name and its content. Please refer to Summarize.

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average for 3 terms in a row

This is where i'm right now..

it indicates an error "The function SUMMARIZE is expecting a table name as argument number 6"

Regular Visitor

## Re: Average for 3 terms in a row

Статистика ретроспективно - is a table name

Community Support Team

## Re: Average for 3 terms in a row

You missed the column name like "sumMeters". Double quotes are needed. You can paste your formula here. I can correct it.

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average for 3 terms in a row

Here is the formula:  VAR Subtotal=SUMX(Summarize('Table name'; 'Table name'[ASSY#]; 'Table name'[Seria#];'Table name'[Repair#];'Table name'[Meters]; SUM('Table name'[Meters])); 'Table name'[Meters]))

Community Support Team

## Re: Average for 3 terms in a row

Hi @Rustami4,

It could be this one:

```VAR Subtotal =
SUMX (
SUMMARIZE (
'Table name';
'Table name'[ASSY#];
'Table name'[Seria#];
'Table name'[Repair#];
'Table name'[Meters];
"SumMeters"; SUM ( 'Table name'[Meters] )
);
[SumMeters]
)```

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.