image-2

How to Compare Sales With Last Year on Day in Week in Power BI

A very normal calculation we do is to compare a value, for example, sales, against how we did last year. The easiest way to do this is by using the SAMEPERIODLASTYEAR function to create a measure that looks like this Sales LY = CALCULATE( [Sales] ,SAMEPERIODLASTYEAR(DimDate[Date]) ) As shown in the image above this works Read More