So you've gone through how to create a date table in Power BI. You've also seen how to calculate Previous Year Sales along with Year to Date using the DATESYTD function in conjunction with the Calculate function. However, calculating the Previous Year to Date needs an extra step. You see with the Previous year to date formula you can then do a comparison between the current year and the previous year. This tutorial will also show you how to formulate a calculation to give you a percentage difference between the years.
Should you want to follow along with this tutorial you might want to download the Power BI Previous YTD exercise file.