Tag: DATEADD Function

Showcase QoQ Sales Using Time Intelligence In Power BI

In this tutorial, we’re going to cover how to calculate quarter on quarter sales differences using time intelligence in Power BI. We’re not just going to do it at a granular level- we are going to try and analyze trends based on quarter on quarter sales. Sometimes when you are looking at something from a

Continue reading

Learn Which Customer Groups Experienced Most Growth Through Customer Segmentation In Power BI

In this example, we’ll run through a unique insight you can discover in Power BI. What we need to do is to combine a range of different formula techniques to get the intended result. If you do this inside your own models with your own customer segmentation analysis, you will discover high-quality insights that will

Continue reading

Use Power BI Analytics To Check If Revenue Growth Is Profitable

Through the example in this tutorial, you will see how powerful Power BI can be as an analytical tool. We will analyze a specific insight using Power BI analytics and then demonstrate it in a compelling way. This analytical work is seriously not possible in any way, shape, or form using existing tools like Excel.

Continue reading

See Changing Results Using Calculated Columns In Power BI

In this tutorial, I’m going to run through a number of great analytical techniques that you can combine and use within Power BI. For your organization, you may want to understand what’s happening or what is causing the underlying adjustments or changes to your data and results. I will show you in this tutorial some

Continue reading

How To Do Trend Analysis In Power BI Using DAX

Power BI Tracking and Visualizing Trends

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this post, I will show how to use conditional formatting inside Power BI tables to showcase this insight really well. Obviously to show a trend analysis in Power BI, we actually need to calculate

Continue reading