Tools to develop models and DAX
You have multiple options to choose from as your tool to work with DAX, depending on the target platform for the model:
- For a Power Pivot model, you use Excel with the Power Pivot add-on.
- For a Power BI dataset, you use Power BI Desktop.
It is interesting to note that there are in fact three versions of Power BI Desktop. One can be downloaded from the Power BI website, powerbi.com. The second is installed from the Windows Store and is automatically updated just like any other app from the store. When you realize that Power BI Desktop gets a new release nearly every month, these automatic updates are a real plus, although it can sometimes be annoying when a new release changes things you do not expect. If you want to, you can install both versions on the same computer. The third version of Power BI Desktop, which can be downloaded from the Power BI website as well, is a special edition for use with Power BI Report Server.
...
