Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
thx, can you give an example in dax for combine and filter?
thx a lot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.