DAX Studio - Building Queries Manually (Using UI)
Since June 2020 a new feature has been introduced in DAX Studio https://daxstudio.org/ that allows you to design queries using the UI, earlier you would have to write code from scratch and this is a great add-on to this tool In this blog I will show you how you can use the interface to create queries yourself. To start with you either need a model inside PBI file, Excel’s PowerPivot or a model deployed in Analysis Services Tabular. First open DAX Studio from start or from PBI/Power Pivot/SSAS and click on Query Builder. Once you click it, it will open the Builder pane. This newly opened pane allows you to drag and drop columns and In this pane you can also add and create new measures. Once you drag columns or measure just click Run Query and Dax Studio will generate result in the result pane If you are like me who likes to investigate the code generated behind the Queries then you can click on “Edit Query” option and it will present the code generated by Query builder. Important Note,