Min/Max lines from another table?

[sfink22]

I have time series data for equipment that I am trying to plot on a line chart with corresponding min/max lines. 

For each product run on the equipment, there is a single established min and max, all in a separate table. For example:

Product Code	Min	Max
A	2	6
B	5	9
C	1	5

My time series data is pulled based on what was run on the equiment that day. Any product can be run on any day, and there can be multiple products over the day. For example:

Product Code	Date	Time	Value
A	3/20/20	10:30 AM	4
A	3/20/20	11:00 AM	4.5
B	3/20/20	12:00 PM	7

I have made a relationship between the tables based on the product code. How do I plot the values for the product across dates and time, and add the corresponding min/max lines as constants on the same line graph? I have a slicer so that you can only view one product at a time, but the min/max lines are still aggregating across the entire data set, not just for the product selected.

[Icey]

Hi @sfink22 ,

If you want to get the Maximum or Minimum value of each product, please try @vivran22 's method.

If you want to get the Maximum or Minimum value of all products, please replace the measures with these ones:

Max Value = MAXX(ALL('Max/Min Table'),'Max/Min Table'[Max])

Min Value = MINX(ALL('Max/Min Table'),'Max/Min Table'[Min])

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

Please find the file attached

[sfink22]

Exactly what I needed! Thank you!

[vivran22]

Hello @sfink22 

Is this what you are looking for?

Solution file here

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn