Tag: SAMEPERIODLASTYEAR

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 customers 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? We’re going to solve this analytical problem with

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