Dax Help

[Ingen84]

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

[PavelR]

Hi @Ingen84. What do you mean by "resolve" to DAX code?

Regards.

Pavel

[Ingen84]

@PavelR EXCUSE ME , I NEED TO TRANSLATE

[LaurentCouartou]

Can you provide a screenshot of what your data model looks like?

[Ingen84]

@LaurentCouartou really sorry but I cant't for privacy, but "Vettore" is a string of characters and "Costo Unitario" is a number.

[PavelR]

@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