From the course: Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Challenge: Create a report showing trends in profitability

Challenge: Create a report showing trends in profitability - Power BI Tutorial

From the course: Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques

Start my 1-month free trial Buy for my team

Challenge: Create a report showing trends in profitability

“

(upbeat instrumental music) - [Instructor] It is time for a new challenge. All you're going to need to do is create a single visual, but to select the right kind of visual, you must first understand the data. Now, Amarillo is our most profitable product in our data set. Let's review some key formula for helping us understand what that means. Sales is gross sales minus discounts. Profit is sales minus the cost of goods sold. And the cost of goods sold is manufacturing price times units sold. Now, here's a table I prepared earlier. It has some extra data fields in it that aren't in the normal exercise files. So for example, it has price difference here. And if we look over here incidentally, this little calculator symbol tells us that price difference is a measure. I've created a measure, and we have sales price times by manufacturing price. Sales price times units sold. Sorry. Which is here. Which you can see is the same as sum of gross sales. So this is me just checking that the…

Contents