Problema con listar ultimos registros.

[juan_M_Estol]

Buenas a todos, 

Tengo dos tablas, "Relevamientos" y "Ductos". 

Necesito crear una tabla nueva resumen que me muestre el ultimo relevamiento de cada ducto.

No logro hacerlo. Cualquier ayuda es bienvenida.

Muchas gracias.

[v-yetao1-msft · Accepted solution]

Hi @juan_M_Estol 

I created a sample with your data .

(1)Create a relationship between two tables with field [Id_ducto]

(2)Add all the fields in a new table visual ,then create a measure to filter the max date for ducto .

Measure =
var _maxdate=CALCULATE(MAX(Relevamientos[fecha_Relevamiento]),ALLEXCEPT(Relevamientos,Relevamientos[Id_ducto],Ductos[nombre_ducto]))
return if(SELECTEDVALUE(Relevamientos[fecha_Relevamiento])=_maxdate,1,0)

(3)Then add the measure in visual filter to filter out the data whose value is 0, and only keep the data whose value is 1 .

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

[lbendlin]

You don't need to join the tables in Power Query - you can do that in the Power BI data model.

The same is true for your filter requirement - that can be done in Power BI by selecting the MAX of fecha_ relevamiento for each nombre_ducto.

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.