Forum Discussion

vacuesta's avatar
vacuesta
Helper I
6 years ago
Solved

DAX and MYSQL syntax

Is there an editor in Power BI that allows you to write in both mysql syntax and DAX syntax? For example I want to use DAX syntax on MYSQL query syntax to run a query.

 

For example: I want to hold an array of values from a query into a variable, then use a DAX for loop to iterate through this array to feed element i into another query to produce data.

 

Is this possible?

Need Help
Tutorial Requests
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    The one when you click on the "Edit Query" button in the Power BI Ribbon.

3 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    6 years ago

    No this is not possible with DAX.

     

    But If your model is in import mode you might be able to do something like this in the Query editor.

    • vacuesta's avatar
      vacuesta
      Helper I
      6 years ago

      Hi,

       

      Which editor are you referring to in this case?

      • d_gosbell's avatar
        d_gosbell
        Super User
        6 years ago

        The one when you click on the "Edit Query" button in the Power BI Ribbon.