Forum Discussion

Ingen84's avatar
Ingen84
New Member
9 years ago

Dax Help

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.ve...
Need Help
PavelR's avatar
PavelR
Solution Specialist
9 years ago

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

 

Regards.

Pavel

Ingen84's avatar
Ingen84
New Member
9 years ago

PavelR EXCUSE ME , I NEED TO TRANSLATE

  • LaurentCouartou's avatar
    LaurentCouartou
    Solution Supplier
    9 years ago

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

    • Ingen84's avatar
      Ingen84
      New Member
      9 years ago

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

      • PavelR's avatar
        PavelR
        Solution Specialist
        9 years ago

        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 :smileywink:

         

        Regards.

        Pavel