Forum Discussion
Sales For Previous Financial Year
Hi,
I have a table which shows sales to date per company for a financial year. I'll create a filter to select the particular year.
I'd also like to include a column which shows sales for the previous financial year up to that date. Is this possible? If so how would I do it?
Cheers
Paul
2 Replies
Take a look here:
Would recommend PARALLELPERIOD or PREVIOUSYEAR
Also, you could check this out:
http://www.daxpatterns.com/time-patterns/
Lots of good guidance there.
You have to have a Date Dimensions table and write the DAX specific to your data names. For example, this is my DAX for previous year total sales:
Previous Year Total Sales – calculated from a table(Named SalesPerformance) showing sales amounts by total sales (Table column named TotalSales) and filtered down to current year through a Date Dimensions Table attached to the report called DimDate using the date column named DateKey.
=CALCULATE(SUM('SalesPerformance'[TotalSales]), SAMEPERIODLASTYEAR(DimDate[DateKey]))
Hope this helps.
