get new table from linked table

[4other]

i have 3 linked table:

tableA whith iddocument, total, date
tableB whith iddetail, iddocument, qta, price
tableC whitn idstorychange, iddetail,user_id, typechange, old_value,new_value, date_change
the tables are linked in powerbi:

tableA join tableB (1-N, tableB.iddocument ->tableB.iddocument)

tableB join tableC (1-N, tableB.iddetail->tableC.iddetail)

in need a new table whith fields:

tableA.iddocument,max(tableC.datechange)

where new_value is in some value and group by tableA.iddocument

in T-sql would be:

select
tableA.iddocument,max(tableC.date_change)
from tableA
inner join tableB on tableB.iddocument = tableA.iddocument
inner join tableC on tableC.iddetail = tableB.iddetail
where
tableC.typechange = 'type1' and tableC.new_value in (5,8) and tableC.user_id in (82,87,90,91)
group by tableA.iddocument

i can't create a view in db, i can only read table, i need solve in powerbi. the table in power bi is imported (not direct query)

thx a lot

[Anonymous]

I would first filter the combined dataset using the standard filter first for Id.document then for new_value. Then group by Id.document, choosing the Max aggregation for the datechange column. 

--Nate

[4other]

thx, can you give an example in dax for combine and filter?

thx a lot