Reply
IcoLogistica
Regular Visitor
Partially syndicated - Outbound

Traer ultimo precio

Buenos dias

 

Tengo una tabla con la relacion de todas las compras efectuadas que se ve asi

 

SKU    Fecha de Compra    Costo Unitario

001      1/8/2021                      2.82

002      1/8/2021                     13.36

001      25/9/2021                     2.99

....

 

Y tengo otra tabla donde tengo el stock por SKU

 

SKU    Stock

001      1207

002       366

Lo que quiero hacer es agregar una columna en la 2da tabla donde me traiga el ULTIMO COSTO de la primera tabla.

 

He tratado con LOOKUP y no me funciona.

 

Por favor ayuda, gracias

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@IcoLogistica , Create a new table

 


new column =
var _max = maxx(filter(Table1, Table1[SKU] = Table2[SKU]), Table1[Fecha de Compra])
return
maxx(filter(Table1, Table1[SKU] = Table2[SKU] && Table1[Fecha de Compra] =_max), Table1[Costo Unitario])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

Syndicated - Outbound

@IcoLogistica , Create a new table

 


new column =
var _max = maxx(filter(Table1, Table1[SKU] = Table2[SKU]), Table1[Fecha de Compra])
return
maxx(filter(Table1, Table1[SKU] = Table2[SKU] && Table1[Fecha de Compra] =_max), Table1[Costo Unitario])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)