Tag: DAX

Understanding LASTNONBLANK For Use In Power BI

The LASTNONBLANK function is an interesting DAX formula that you can utilize in a number of different ways inside of Power BI. It is not a very used DAX formula because of the complexities around how it calculates results. Most Power BI users, I would presume, don’t even realize that they can utilize the function

Continue reading

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

In this video tutorial I’m going to show you how you can segment your customers in an efficient way 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

Continue reading

Segmentation Of Your Data Based On Rankings – 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 try and segment our dimensions. We will segment some table in our data by the ranking of a dimension in that particular table. There’s a little bit to this but it’s a really amazing concept of how

Continue reading

Analyze Margin Changes Overtime – Analytics with Power BI and DAX

Through this really unique and specific example I’m going to dive into how you can combine lots of the techniques that I’ve described in many tutorials and posts in the past. These are techniques like Measure Branching, Trend Analysis, and DAX formula combinations. What we are going to do is analyze the changes to profits

Continue reading

Analyze & Showcase Quarter On Quarter Sales Trends In Power BI

In this tutorial we’re going to cover how to calculate quarter on quarter sales differences. We’re not just going to do it at a granular level, like at a daily level. We are going to try and analyze trends around quarter on quarter sales. Usually when I suggest trends around our results, what I mean

Continue reading