Vs Previous Working Day Last Year

[Caldowd98]

Hi Community

I have a table similar to the below where i am looking to create a measure that calculates the units for the same Month, Same working day but the previous year.

Date	Working Day	QTY	Vs Previous Year
01/08/2022	1	1000	?
02/08/2022	2	1250	?
05/08/2022	3	1500	?

Is there a way to acheive this ? I have a date table already set-up with the working day included.

Thanks !

[Anonymous · Accepted solution]

Hi @Caldowd98 ,

Please try

Vs Previous Year = 

CALCULATE(
    [Sales Amount],
    DATEADD('Calendar'[DateKey],-1,YEAR
    )
)

Hope that helps, please mark this as a solution if it helps

Regards

[NickA01]

HI, 

Sorry for obvious question but have you tried SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs
and if so, what error\ issue have you encountered? 

The Nick

If the post helps please give a thumbs up || If it solves your issue, please accept it as the solution to help the other members find it more quickly.

If it's the biggest heap of stinky smelly stuff then I'm sorry .