cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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.

1 ACCEPTED SOLUTION
Super User

4 REPLIES 4
Community Support

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.

Super User

Helper I

Exactly what I needed! Thank you!

Community Champion

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/