Forum Discussion

sfink22's avatar
sfink22
Icon for Helper I rankHelper I
6 years ago
Solved

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,...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

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.