Maximum and minimum of average on a selected date(s)

[Jayana]

Hi All,

I'm in my first week with PowerBI and need some help.

I'm working with data at minutely intervals comes from many sensors and trying to

determine maximum/minimum values for a selected date(s). The data looks like below:

Original data

Date_time                               Sensor1   Sensor 2 ...

01/01/2017T12:00:00+10:00       28.1          18.7

01/01/2017T12:00:01+10:00       25.7          15.6

01/01/2017T12:00:02+10:00       25.6          18.5

Then I pivoted it in Power BI to

Date_time                                    Sensor     Measure

01/01/2017T12:00:00+10:00       Sensor1    28.1

01/01/2017T12:00:00+10:00       Sensor2    18.7

01/01/2017T12:00:01+10:00       Sensor1    25.7

01/01/2017T12:00:01+10:00       Sensor2    15.6

01/01/2017T12:00:02+10:00       Sensor1    25.6

01/01/2017T12:00:02+10:00       Sensor2    18.5

Then I grouped them, using group function in Power BI, into groups,

let's say Sensor1 and Sensor2 together for the above data. I managed to

create a graph out of average between those two sensors however when

I used Card to determine maximum/minimum value for a date(s) that I selected, 

I got the maximum/minimum of individual sensor not the maximum/minimum of

average of the two sensors. For the above data, I got 28.1 but I wanted to get 23.4

 for 1/01/2017, which is max of average between Sensor1 and Sensor2 (28.1+18.7)/2.

Any advice how I can achieve this (maximum or minimum)? This should be filtered to

date(s) selelected by users.

Thanks in advance for any help.

Regards

Jayana

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[Jayana]

Hi Ashish,

Brilliant, it works like magic.

Thanks for your help.

Jayana

[Ashish_Mathur]

You are most welcome.

[Jayana]

Any help please.