I’ve previously showcased how you can compare your actual results versus your budgeted results using advanced DAX. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select?
Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking in Power BI. We’re going to create dynamic visuals containing our top 10 customers for specific products. This is a really powerful technique that
As soon as you start developing a few Power BI models, you’ll very likely run into a problem where you have two dates in your fact table and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date, invoiced date, shipped
There will be countless times when you will be required to calculate your sales financial year to date, but only the standard date table is available. One thing that can seem like a limitation of Power BI is its calendar date table. You may initially think that you need a new date table, but you
In this post, I run through how to use SAMEPERIODLASTYEAR, a time intelligence function, to compare results from this year with those of last year. If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions.