Tag: Sales Profit Analysis

Show Changes Over Time In Power BI Reports

By Sam McKay, CFA on September 12, 2020September 7, 2020

In this Power BI Showcase, we’re going to focus on time intelligence in Power BI to showcase how our business metric changes over time. We have a reseller of a product that’s being sold throughout the East Coast of Australia. We want to analyze all their key metrics which includes Sale and Profits among other

Posted in: Business Metrics, Moving Average, Profit Margins, Sales Profit Analysis, Time Intelligence, Time Intelligence Examples, Time Intelligence Power BI, Top and Bottom Results

Business Intelligence Data Visualization DAX Power BI Time Intelligence

Power BI Trend Analysis: Are Margins Expanding Or Contracting?

By Sam McKay, CFA on December 18, 2019October 13, 2020

In this blog post, I will be diving into a relatively specific insight by conducting a Power BI trend analysis. By walking through exactly how I got there, you will learn so much about what you can do with Power BI and DAX. I really dive into this concept of measure branching, which I love

Posted in: Advanced DAX, Conditional Formatting, Measure Branching, Profit Margin Analysis, Sales Profit Analysis, Time Intelligence Calculations, Trend Analysis