Forum Discussion

Angus01's avatar
Angus01
Regular Visitor
2 years ago
Solved

Point at which two lines converge

I have two lines on a graph, one of which is dynamic based on some "what if" parameters. I want to find the point on the x axis where the 2 lines meet.    https://www.dropbox.com/scl/fi/oo3kn...
Need Help
  • Angus01's avatar
    Angus01
    2 years ago

    So I took your inspiration and managed to get it to work using: 

    backlog_crossover_date = 

var crossover = MAXX('Calendar Table', if([Forecast Plus Backlog] - [Regression line by hours] > 0, 'Calendar Table'[Date], date(2000, 1, 1)))

var result = if(crossover <= DATE(2025, 3, 30), crossover, "No Crossover")


RETURN

result

     

    it may not be the most elegant but it works!

Angus01's avatar
Angus01
Regular Visitor
2 years ago

Thank you for this. It feels like a step in the right direction but what I am really trying to do is get a single value for the first point of conversion, such that I can display it on a card or similar. 

 

Angus01's avatar
Angus01
Regular Visitor
2 years ago

So I took your inspiration and managed to get it to work using: 

backlog_crossover_date = 

var crossover = MAXX('Calendar Table', if([Forecast Plus Backlog] - [Regression line by hours] > 0, 'Calendar Table'[Date], date(2000, 1, 1)))

var result = if(crossover <= DATE(2025, 3, 30), crossover, "No Crossover")


RETURN

result

 

it may not be the most elegant but it works!