Microsoft Power BI Quick Start Guide by Devin Knight

Author:Devin Knight
Language: eng
Format: epub
Tags: COM005030 - COMPUTERS / Enterprise Applications / Business Intelligence Tools, COM089000 - COMPUTERS / Data Visualization, COM062000 - COMPUTERS / Data Modeling and Design
Publisher: Packt
Published: 2018-07-30T06:41:35+00:00

One of the benefits of creating explicit measures is the ability to centralize formatting. Once the measure has been created, navigate to the modeling ribbon and change the formatting to $ English (United States), as shown in the following screenshot:

Figure 11-Change formatting to $ English(United States)

Total Cost

Now let's create the Total Cost measure. Once again, this is a simple SUM operation. Click New Measure... from the modeling ribbon and type in the following DAX formula:

Total Cost = SUM('Internet Sales'[Total Product Cost])

Remember to apply formatting to this new measure; it is easy to miss this step when learning to create measures. The formatting should be $ English (United States).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.