Advantages of using DAX Query View in Power BI | Xyclos
In Power BI Desktop we have a very useful tool to visualize the results of DAX instructions before using them in our Model.
It is called DAX Query View available in the Navigation Pane containing Report View, Table View, Model View.
How does DAX Query View work?
Very easy.
Click the DAX Query View icon
Enter EVALUATE
Enter the DAX statements you want to test: EVALUATE FILTER (dimSellers, [Total % target fulfillment] > 1 )
Click on the Run button At the bottom of the Power BI screen, it displays the result of the statement. If you wish, you can name the query by double-clicking on the name of the tab, enter the name and press the Enter key. You can delete the query by clicking the X ( Delete Query ). This action has no effect on any Model calculations.
Format a query
Click any Dax statement in the query
On the Ribbon, click the Format Query icon Power BI will wrap the DAX statements as closely as possible, making them easier to read. EVALUATE FILTER ( dimSellers, [Total % achievement of objectives] > 1 )
Copy results
If the query gives you the expected result, you can copy and paste it to create Measures or use it in Table View to create calculated tables or calculated columns.
View all Model measurements using the DAX Query View
Click the DAX Query View icon
In the Tab Bar , click + (New Query)
In the Data pane, right-click on a Model table
Click Quick Inquiries
Then click Define all measures for this model Power BI automatically runs the query and outputs the result to a one-row table that contains the result in an individual column or field, for each measure created in the .pbix file.
View the DAX statement of a measure, using the DAX Query View
If the DAX statement you are evaluating has measures , hover over the measure .
Power BI displays the DAX instructions of the measure
Add comments to the query, using the DAX Query View
Create a new line where you want to enter the comment
Enter comment text
On the DAX Query View Ribbon, click the Comment icon
Power BI adds at the beginning of the entered text: // which is used to define a text or statement as a comment
Transform your career with Power BI at Xyclos Academy!
Can you imagine mastering Power BI and becoming the star of your team?
Our courses not only provide you with advanced tools and knowledge, but also help you transform your professional life.
Enroll today and begin your journey toward excellence in data analytics and business management!
Comments