Computer Tutoring Logo
Est. 2002
Menu Button

How to work out previous year to date in Power BI?

Formula to work out Previous Year to Date?

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.