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
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
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
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
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
