For the second argument, Quantity is multiplied by the Unit Price.Ĭhange the name of the measure to Total Sales. The table used for the first argument is the Sales Table. It also informs you that the first and second arguments to be used should be a table and an expression, respectively. The box shows that the function is an iterator. You can also see a suggestion box about the function being used. If you input SUMX, an open and close parenthesis appears. In this example, you can see that the Sales is suggested using the keyword SUP.įor this measure, use the SUMX function to get the Total Sales.
If you write the initials of a table or column, Tabular Editor will find the table or column that matches the initials. In this example, you’ll see the functions that are related to the keyword SUM. The box contains all functions with the given keyword. If you input a keyword of a function in the Expression Editor, a suggestion box will appear. The remaining columns can be used in functions like COUNTROWS and DISTINCTCOUNTNOBLANK. These columns can be used in functions like SUMX, MINX, MAXX, among others. Your workspace will then look like this.įor the measure, the Unit Price, Quantity, and Unit Cost columns will be used. Place the Sales table on the right side of the screen. Right-click on the Sales table and select Preview Data. You can open the Sales table to see which column can be used in the measure. In this example, the Sales table is used to create a measure. To create a measure, right-click on a table and select Create. Create Measures For Total Cost and Total Profit.
0 kommentar(er)
