Tag: Calculated Columns

Segmenting Dimensions Based On Ranking – Advanced Analytical Technique For Power BI

In this example, we’re going to get quite advanced in Power BI using DAX. We are going to focus on segmenting dimensions based on its ranking on that particular table. This is an amazing concept of how you can utilize calculated columns within Power BI. This can bring additional insights that would have never been

Continue reading

Show Results Up To Current Date Or A Specific Date In Power BI

In this tutorial, I’ll show you a very specific technique where you can show data or filter up to the current date (today) or any specific date in your Power BI reports. I’ve seen this asked a few times, especially on the Enterprise DNA Support Forum. I’ve personally used this technique many times, so I

Continue reading

Filtering Data By Custom Fiscal Years And Quarters Using Calculated Columns In Power BI

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

Continue reading

Customer Segmentation Techniques Using The Data Model – Power BI & DAX

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

Continue reading

How To Create Unique Financial Year Quarters Using A Calculated Column

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

Continue reading