Forum Discussion

paulsmit's avatar
paulsmit
Frequent Visitor
4 years ago
Solved

Minimum and Maximum weekly average by location

Hi,   I'm looking to see if the gap between the highest weekly location average index and the lowest weekly location average index is growing.     Week Location Index 1 Hartington 100.0...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Ah, OK.

    Min Index = MINX(
        ADDCOLUMNS( SUMMARIZE( 'Table', 'Table'[Location] ), "@avg", CALCULATE( AVERAGE('Table'[Index]) ) ),
        [@avg]
    )

    I think that should do it.

johnt75's avatar
johnt75
Super User
4 years ago

Create the below 3 measures

Min Index = MIN( 'Table'[Index] )
Max Index = MAX( 'Table'[Index] )
Diff between Min and Max Index = [Max Index] - [Min Index]

Then add all 3 measures to a table, or other visual, with the Week column from your table

paulsmit's avatar
paulsmit
Frequent Visitor
4 years ago

Apologies, I probably didn't explain in my initial post that I need to average the index for each location before I find the min and max values