Forum Discussion
Previous Year Sales
Hi, I am trying to calculate last year sales using minimum line of dax code as below: Sales Last Year = CALCULATE( [Sales] , PREVIOUSYEAR('Date (Sales Order)'[Order Date] ) ) It gives cor...
Syndicate_Admin
Administrator
AdministratorDear, this would be the measure to create:
Sales Previous Year = CALCULATE([Sum Sales],DATEADD(Calendar[Date],-1,YEAR))
So you can get the sales of the previous year.
Syndicate_Admin It shows the total sales amount when place on a card visual. I need to show only last year sales when place on a card visual.