Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX

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?

Continue reading

Using Dynamic Visuals On Ranking Based Parameters In Power BI

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

Continue reading

How To Work With Multiple Dates In Power BI

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

Continue reading

Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX

Calculate Financial Year To Date FYTD Sales In Power BI using DAX

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

Continue reading

Using SAMEPERIODLASTYEAR To Compare The Difference Between This Year & Last Year

Using SAMEPERIODLASTYEAR To Compare the Difference Between This Year & Last Year

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.

Continue reading