Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Min and Max Columns summarising multiple rows

Hi all,    I have a large dataset of half hourly temperatures for two decades. I have created a column which summarises the same days across the multiple years, from 1 to 366 ("Day" column). I need...
Need Help
  • barritown's avatar
    barritown
    3 years ago

    Hi Anonymous,

    If I've correctly understood your task, you could solve it with the help of the three measures below and a table visual:

     

    MinTemp = MIN ( [Temperature] )

MaxTemp = MAX ( [Temperature] )

AvgTemp = ( [MaxTemp] + [MinTemp] ) / 2

     

    In the test case below you can see dates, but it will work with days too:

     

    Best Regards,

    Alexander

    My YouTube vlog in English

    My YouTube vlog in Russian

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

You can try to use following calculate columns formula to get the max and min temperature based on current date:

daily MinT =
CALCULATE (
    MIN ( Table1[Temperature] ),
    FILTER ( Table1, Table1[Date] = EARLIER ( Table1[Date] ) )
)

daily MaxT =
CALCULATE (
    MAX ( Table1[Temperature] ),
    FILTER ( Table1, Table1[Date] = EARLIER ( Table1[Date] ) )
)

Regards,

Xiaoxin Sheng