Once you get more and more into advanced DAX formulas, you will see the world of analytical opportunities immeasurably expand for you. In this example I will show you by just how much. In this blog post, I am going to explore some relatively advanced DAX logic and then build upon it by combining an
As many of you know by now, I am huge on showcasing how you can apply Advanced DAX Formula to discover insights that historically have been difficult to find and also showcase easily. Well, this is another example of that and a great way to segment or group results rather than just showing results by
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
Have you ever wanted to create a visualization that changes based on any ranking selection you could make? You can actually change the size of your Power BI visuals by ranking logic. Think of a scenario where you want to showcase your top 20 clients. Pretend you’re in a meeting saying, “These are the clients
Did you know there is a way to create groups virtually in Power BI? I was so happy when I discovered this, as it allows you to quickly and effectively create another grouping dimension in your data sets or data tables. The Power BI team has made it so easy to implement and edit as
