Please help to calculate delays between three dates of three different table

[Pamplemousse]

Hello,

i'm beginner in power bi et trying to calculate delays between three dates of three different table.

Each "n° op" may have severals "commandes" and each "commande" may have severals "reception". I'd like to calculate the mean delay between "date de commande" and "date de mad finale", and "date de mad finale" and "date de reception". The "date de mad finale" is unique per "n° op". 

My mesures : 

Délais MAD-Commande = datediff(LASTDATE(Commandes[Date de commande]),LASTDATE(MOE_FINAL[Date de MAD Finale]),DAY)

Délais Réception-MAD = datediff(LASTDATE(MOE_FINAL[Date de MAD Finale]),LASTDATE('Réceptions'[Date de réception]),DAY)

They are not working at all, it shows dates of "commandes" that are not even related to "n° Op".

Could you please help ? 

[johnt75]

You could try

Delay MAD-Commande = AVERAGEX(Commandes,
DATEDIFF( Commandes[Date de commande], RELATED(MOE_final[Date de MAD]), DAY)
)

Delay Reception - MAD = AVERAGEX(Receptions,
DATEDIFF( RELATED(MOE_Final[Date de MAD]), Receptions[Date de reception], DAY)
)

[Pamplemousse]

Thank you for your help, but i doesn't seem to work, something still goes wrong 

[johnt75]

Those all have the same No OP, so they would have the same average for MAD- commande. For the other one, you may need to swap the order of the dates in DATEDIFF

[Pamplemousse]

The problem is, for exemple, the first op_0012 has only one "commande", i don't know why it shows all the others 

[johnt75]

which table is No Commande - No Poste  in the visual coming from, it seems to exist in 2 tables in the model?

[Pamplemousse]

It comes frome "Commandes" table, but i tried with the one of "Receptions" table, nothing changed.

[johnt75]

Is it possible to share a PBIX with any confidential information blanked out?