There can be times when your date tables won’t have the custom fiscal years and quarters that you require as filters for your analysis. In this tutorial, we are going to discuss how you can filter your data by financial or fiscal years and quarters using calculated columns in Power BI. I’ve already seen inquiries
In this blog post, I’m going to show you how to do customer segmentation techniques via the data model in Power BI. Sometimes your raw data will not have all the information you require to showcase something in Power BI. But don’t let this stop you. All you require is an imagination around how you
If you had the opportunity to view the detailed date table tutorial that I ran through in a previous post, you will find that most of the supporting date columns like months, quarters, and financial years are generally made up for a standard calendar date table. In a lot of cases though, you need to
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
In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. I will go over each one at a time and I’ll start with calculated columns. Using Calculated Columns A calculated column is an additional column that doesn’t exist in your
