Tag: SWITCH Function

How To Use SWITCH True Logic In Power BI

When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. In this tutorial, I’ll run through how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights within Power BI. There

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

Data Visualization Technique in Power BI – Multi Measure Dynamic Visuals

This blog post will demonstrate one of the best data visualization techniques I’ve discovered in Power BI to date — the multi-measure dynamic visuals technique. If you want to create dynamic visuals that can really make your analysis stand out, you need to make use of it. It allows you to work and present your

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