Analyze & Showcase Quarter On Quarter Sales Trends In Power BI

3 comments

In this tutorial we’re going to cover how to calculate quarter on quarter sales differences.

We’re not just going to do it at a granular level, like at a daily level. We are going to try and analyze trends around quarter on quarter sales.

Usually when I suggest trends around our results, what I mean is we want to smooth the results we are seeing.

Sometimes when you are looking at something at a very granular level, your visualizations as a whole will become very busy.

If you can smooth the results that you’re looking at, it enables you to produce is a much more compelling visualization which showcases something a little bit more meaningful than a busy chart which shows every adjustment or change in your result through time.

It’s a two-fold example that I will run through here. Not only are we going to run through how to visualize time calculations around different time periods, one quarter versus another quarter. We’ll also analyze the difference. 

A lot to go over in this tutorial, a lot of functions but also visualizations.

For many more time related insights that you can discover and showcase with Power BI, check out this detailed course module at Enterprise DNA Online.

Time Intelligence Calculations

Enjoy diving into this tutorial.

Sam

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

 

***Learn more about Enterprise DNA Membership***membership banner 3

3 comments on “Analyze & Showcase Quarter On Quarter Sales Trends In Power BI”

  1. Hi Sam,
    This is a great tutorial, but are you aware of any workaround to create a QoQ metric based on a fiscal quarter?
    Thanks in advance!
    Ben

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.