Select Model from the left edge of the Power BI Desktop. You can also organize fields in a table into Display Folders. You can change their location by choosing a location from the tables in your model. Measures have a Home table that defines where they're found in the field list. This approach is especially useful when you want to link to other Power BI reports with URL filter parameters. You could create tables that display the measures as Web URLs, and be able to select on the URL that's created based on your selection. You can also pick data categories for measures.Īmong other things, data categories allow you to use measures to dynamically create URLs, and mark the data category as a Web URL. Janice can further analyze the projections by filtering on specific resellers or by adding other fields to the report.

Quickly and with minimal effort, Janice now has a measure to calculate projected sales. Janice then drags the new Projected Sales measure into the chart. Janice creates a new measure by using the New Measure feature, then enters the following DAX formula: Projected Sales = SUM('Reseller Sales')*1.06 For this calculation, Janice will create a measure. Power BI Desktop created its own measure by summing up all of the values in Last Years Sales.īut Janice needs a measure to calculate sales projections for the coming year, which will be based on last year's sales multiplied by 1.06 to account for the expected 6 percent increase in business. Janice notices that even without specifying a calculation, one has been provided automatically. It appears in a chart visualization as a single value that is the sum of all reseller sales from last year. Janice then drags Last Years Sales onto the report canvas. Because the imported data only contains sales amounts for last year, Janice renames the SalesAmount field to Last Years Sales. Janice finds the SalesAmount field in the Reseller Sales table. To report the estimates, Janice imports last year's sales data into Power BI Desktop. Janice decides to base the estimates on last year's sales amounts, with a six percent annual increase resulting from various promotions that are scheduled over the next six months. Janice has been asked to provide reseller sales projections over the next fiscal year. But the DAX functions are meant to work with relational data like we have in Power BI Desktop.

DAX even has many of the same functions as Excel, such like DATE, SUM, and LEFT. Its library provides immense flexibility in creating measures to calculate results for just about any data analysis need.ĭAX formulas are a lot like Excel formulas. DAX includes a library of over 200 functions, operators, and constructs. When you create your own measures, you’ll use the Data Analysis Expressions (DAX) formula language. Measures calculate a result from an expression formula. For more information, see quick measures. They're a good way to quickly create measures, and also a good way to learn Data Analysis Expressions (DAX) syntax, since their automatically created DAX formulas are available to review. You might also be interested in quick measures, which are ready-made measures you can select from dialog boxes.

Learning microsoft power bi desktop