power bi get new table filed from linked table

Question

i have 3 linked table:

1. tableA whith iddocument, total, date
2. tableB whith iddetail, iddocument, qta, price
3. 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