The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi, I need to resolve this SQL code into DAX Code
SELECT c.consumo * a.costoUnitario
FROM c JOIN b ON c.vettore = b.vettore
JOIN a ON a.vettore = b.vettore
WHERE c.vettore = a.vettore
Thanks to everyone
Can you provide a screenshot of what your data model looks like?
@LaurentCouartou really sorry but I cant't for privacy, but "Vettore" is a string of characters and "Costo Unitario" is a number.
@Ingen84 If you have two datasets in Query editor, you can use Merge queries option to join them. There is also the option to specify whichc join condition will be used (left join etc.)
Maybe it could help you
Regards.
Pavel