Forum Discussion
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...
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] ) / 2In the test case below you can see dates, but it will work with days too:
Best Regards,
Alexander
barritown
Solution Sage
Solution SageHi 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