Forum Discussion
Solved
Find and return intersection points between lines
Hello, I'm working on an analysis comparing scenarios and I would like to find the intersection point(s) between lines. Below is an example of a graph I can plot and I would like to calculate at wha...
replace
SELECTCOLUMNS ( IntersectionPointsTable, "Temperature", [Temperature], "GHGValue1", [GHGValue1], "GHGValue2", [GHGValue2] )with
CONCATENATEX( IntersectionPointsTable, [Temperature], ", ", [Temperature], ASC )
You can linestx to get the y = mx + a for the straight line.
The curved one will be more difficult.
If you had both definitions you could solve exactly with some algebra.
You could estimate the points. Would that be acceptable?
That would be complicated as some of the data is more in buckets (is flat for a few temperature points then changes) and some is not linear (like example above)
