Forum Discussion
vacuesta
Helper I
6 years agoDAX 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?
The one when you click on the "Edit Query" button in the Power BI Ribbon.
3 Replies
- d_gosbell
Super User
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.