Obtain maximum value (envelope)

[Jond]

Hello,

I have some data visualized in Power Bi using R scripts (ggplot2 library). Field data (two variables, y as a function of x, black points) and two constant theoretical curves (red).

Data from several days

In order to compare the field data with the theoretical curves, I would like to obtain the maximum and minimum y values per x value per day. For example:

Day 1

Day 2

The objective is to obtain "envelope" curves, get rid of the rest of data and compare them in one visual respect to the theoretical curves. 

Any ideas? How can I obtain the values in R script or in the query?

Thanks

[v-yuta-msft]

@Jond ,

I think you can use dax instead, could you share the sample data and the output result?

Regards,

Jimmy Tao

[Jond]

I share some sample data (raw and sample report):

https://www.dropbox.com/sh/6lxcf9dj4v0yjoa/AAB8ClxYanQ70P5f73uwxbtga?dl=0

This should be the output result:

For each x value, the maximum and the minimum of y are stored and the rest of the data is discarded. The figure shows the maximum and the minimum values of y for a range of x. Each color is a different day.