Tag: SAMEPERIODLASTYEAR

Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

Showcasing Growth Performance Effectively In Power BI - Advanced DAX

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. You may watch the full video of this tutorial

Continue reading

Evaluating Customer Margin Contraction Using Power BI

Here we’re going to look at customer margin contraction. We’re going to try and work out what customer margins are contracting and why are they contracting. Is it because of their purchasing frequency? Is it because of the products they’re buying? Or because of some other reason? You may watch the full video of this

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. You may watch the full video of this tutorial at the bottom of this blog. If you want to start creating compelling reports with strong insights into information over time,

Continue reading