topic Re: DAX Last Year Sales in Developer

DAX Last Year Sales

minimynt — Wed, 13 Jul 2016 03:33:13 GMT

Hi,

I want to create LY Sales calculation, but somehow there's something wrong with the result.

The total of LY Sales is right, but I don't have any idea why LY sales for each year is not showing.

Here is my formula

LY Sales = CALCULATE([Total Sales], DATEADD(Orders[Order Date],-1,YEAR))

Does anybody know why? 😞

Thanks,

Priscilla

Re: DAX Last Year Sales

Anonymous — Thu, 14 Jul 2016 13:34:00 GMT

Hello, try this instead: LY Sales = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Orders'[Order Date]))

If you have a dedicated date table, you'll want to use the date column from there instead of Order Date

Re: DAX Last Year Sales

minimynt — Tue, 19 Jul 2016 02:32:14 GMT

@Anonymous Hi, I've also tried with SAMEPERIODLASTYEAR but the result is the same. However, I just figured out that only continuous date is valid for this case and my OrderDate isn't continuous so that's why.

Thanks anyway! 🙂

Re: DAX Last Year Sales

sure19 — Wed, 08 Feb 2017 04:54:28 GMT

Hi,

first i have filtered year, then inserted region and sales, when i try to use the above to calculate last year sales, it gives me blank. is it because i have already filtered the year? how can i still show last year sales against this year sales?

thanks in advance

Suresh

Re: DAX Last Year Sales

Anonymous — Wed, 08 Feb 2017 13:16:38 GMT

Is your date column continuous? If you're using a seperate date table, did you create the relationship using 2 fields with a Date data type?

Re: DAX Last Year Sales

vicks — Tue, 27 Feb 2018 07:26:23 GMT

Hi Suresh;

Did you solved your problem?, i have same issue about that, the formula didnt worked when i filtered by Year;

i have single fact table with sales measure, person dimension, Year, Month, Date(dateSQL) Dimension;

warm regards;

Opik

Re: DAX Last Year Sales

Anonymous — Fri, 14 Jan 2022 19:28:17 GMT

Hi Guys,

I know it's quite irritating to get the prior year meaures. I tried looking everywhere left with no choice than to try all by myself. Please find the solution below

LY Sales = CALCULATE([Total Sales],Calender[Year] = YEAR(TODAY()) - 1)

Total Sales = Your measure

Calender = Your date table

I am just subtracting 1 from the current years number in this expression YEAR(TODAY()) - 1).

Please accept it as a solution if it resolved your issue