cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rustami4 Regular Visitor
Regular Visitor

Re: Average for 3 terms in a row

i mean what this column calculates

Rustami4 Regular Visitor
Regular Visitor

Re: Average for 3 terms in a row

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

Community Support Team
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.
Rustami4 Regular Visitor
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"

 

Screenshot.PNG

 

 

Rustami4 Regular Visitor
Regular Visitor

Re: Average for 3 terms in a row

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

Community Support Team
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.
Rustami4 Regular Visitor
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
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.