Fusionar consullta por valor minimo de un campo or left join with conditions

[matihernandez94]

Estimados, 

Esperando que se en encuentren bien les queria consultar si ustedes saben como hacer para unir dos tablas por un campo el cual sea la fecha minima. La tabla A trae datos unicos , pero la tabla B trae datos duplicados en el cual puede traer varias fechas para el mismo campo.

Ustedes saben como hacer para que te traiga solamente la fecha mas antigua a la hora de combinar consultas.?

Hoping that they are well, I wanted to ask you if you know how to do to join two tables by a field which is the minimum date. Table A brings unique data, but table B brings duplicate data in which you can bring multiple dates for the same field.

You know how to make it bring you only the oldest date when combining queries¡.

[v-eqin-msft]

Hi @matihernandez94 ，

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @matihernandez94 ,

Did you try GroupBy feature in Power Query:

If it does not make sense, please take a look at these similar threads which may help you resolve it:

Merge one table to another based on min-max values

Nested Calculations In Power Query

Conditional Merge in Power Query

https://community.powerbi.com/t5/Desktop/Table-merge-in-Power-Query-based-on-conditions/td-p/183425

Or please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[matihernandez94]

Thanks Evelyn.  Muchas gracias me sirvio mucho tu propuesta Saludos.

[amitchandak]

@matihernandez94 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

what can do is follow the reverse of this blog, get oldest record -https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/

and then merge two tables