Previous Year & Current Year total sales calculation

[Manivannan]

Hi All,

How to calculate the total sales happened in pervious year & current year?

Regards,

Manivannan M

[GilbertQ · Accepted solution]

Hi @Manivannan

In order to do this you will first need to create a Date table and map it to your existing dataset.

Here is a link below on how to create the table: https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fi...

Once that is done you can then use the build in Time Intelligence features to calculate the Current and Previous Year Totals with the DAX measure examples below, where you would put the columns from the date table into your visual or table.

Sales = SUM('My Table'[Sales Amounts])

PY - Sales = CALCULATE([Sales],PREVIOUSYEAR('Date'[Calendar Date]))