Define the crossing of the curves with DAX

[Anonymous]

Hey guys,

Below is the problem i am trying to solve since two days now.

Here is my dataset :

My final goal is to find the date when the two curves "Entrées" and "Sorties" will cross.

For that, i calculated the column :

• EcEntrées, which is the gap of "Entrées" between a date and the previous date.
• EcSorties, which is the gap of "Sorties" between a date and the previous date.
• AvEcEntrées, whch is the average of the gap of "EcEntrées", calcultaed with the column : 
  • AvEcEntrees = AVERAGEX(FILTER(ALL(Projection_light);([Date]>=EARLIER([Date])-1) && [Date] <= EARLIER([Date])-0);[EcEntrées])
• AvEcSorties, which is the same for the "Sorties".

Now, I would like to find the value of X for the equation : LastDate(Entrées) + AvEcEntrées x X = LastDate(Sorties) + AvEcSorties x X

I dont know at all how to solve it with dax ... Is it a measure ? Is it a column ?

Ty for your help !