Forum Discussion
Min/Max lines from another table?
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.
Please find the file attached
4 Replies
Please find the file attached
Exactly what I needed! Thank you!
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.
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
