Improper Functioning of PreviousYear Function

[wasequesiddiqui]

I am trying to get the sales of Previous Year but somehow previousyear function is not giving me the desired result. [LY Sales Col] is my previous year sales column.

[v-haibl-msft · Accepted solution]

@wasequesiddiqui

You need to create a calendar table and create relationship between these two tables with Date key. Then use PREVIOUSYEAR Function (DAX) like below.

LY Sales =
CALCULATE ( SUM ( SALESSHEET[Sales] ), PREVIOUSYEAR ( 'Calendar'[Date] ) )

Best Regards,

Herbert

[wasequesiddiqui]

Thanks for the prompt response. Your solution worked like a charm!

[wasequesiddiqui]

 

I have tried changing the column for previousyear function still it is not working