FInding MAX and MIN Value in a fixed time range

[Chavadaba]

been stuck at this for a couple of days now, I have a Start date and a known duration (in days) of a buying operation, bought is made in USD against MXP, I have daily exchange rates, I have been able to obtain DAily, weekly and monthly averages, min and max, but what I need is the average in the duration of the operation and min exchange rate and max exchange rate in the same amount of time. 

Hope u can help. attached images of what I have done so far. Thank you. 

[Anonymous]

In such similar case can anyone help me how to find avg of time, group by a couple of columns?
we have only latest & earliest options availble, hence i am trying out with DAX function to get avg time calculated group by ID

[Chavadaba · Accepted solution]

Seems I was overthinking :(, it has a very simple and logic solution, I just create a copy of my FIX Historico (2) table, and DO NOT create any relationship between the tables, then use some simple dates between measures and tada !!!! Can't believe I was stuck on that for a week. Just posting in case anyone has the same issue later. 

[v-jiascu-msft]

Hi @Chavadaba,

Can you share the original data in TEXT mode or the pbix file? 

I think you need functions AVERAGEX, SUMMARIZE in your scenario.

Best Regards,

Dale

[Chavadaba]

thanks for your time, attached PBXI bellow, thank you. Like I told you in the table contratos2018Tiempos I have REAL ETD (stardate), and FECHA LIMITE DE PAGO (end date), in the table FECHA CONTINUA CONTRATO I have the excahnge rate for each day since 2013 I need to get minimum and the maximum exchange rate between the start and end date. 

https://www.dropbox.com/s/ekq8rm97spww185/Diferenciales%20Cambiarios%20v%203.0.pbix?dl=0