Total Sales

To create your first measure, select the Internet Sales table and then click New Measure... from the modeling ribbon. In the formula bar, type the following code and hit Enter:

Total Sales = SUM('Internet Sales'[Sales Amount])

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)
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
52.15.135.175