Forum Discussion
Lexicon/Dictionnary with DAX Functions and SQL statement ?
Hello all,
I am a beginner with Power BI and I would like to learn more about it. Does anyone have an excel file or a lexicon with the most important and useful SQL Statements or DAX Functions?
It could be nice for us, like a dictionary.
Have a nice day!
Here is how to do it for Power Query
#sharedHow to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
There is no such built in dictionary for DAX but you have Intellisense (while you type function names it shows the expected parameters) and you have very good documentation on the interwebs for all DAX functions
2 Replies
Here is how to do it for Power Query
#sharedHow to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
There is no such built in dictionary for DAX but you have Intellisense (while you type function names it shows the expected parameters) and you have very good documentation on the interwebs for all DAX functions